Re: MSSQL to MYSQL

[Sasha Pachev]

Steve Layton wrote:
> 
> I am a developer looking to get rid of my MSSQL servers and rewite some
> software to only run on linux, I have a copy off the SQL script I used to
> make the Database, tables and triggers in my MSSQL database. I am wondering
> how I can execute a .SQL(text file) from the command line to run all of the
> SQL command sthat I already have, to rebuild my Database strucure and
> triggers without having to hand puch all of them.
> 
> Thanks
> 
> Steve

You may need to do some tweaking to your sql to make it
mysql-compliant ( as some sql features are missing, but
workarounds are available), but other than that,

mysql -uuser -ppass < mssql.sql 

will do the job.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)