Translate SQL Server scripts into MySQL

[sebes]

Hello !

I have the scripts for creating all the tables in a SQL Server database and would like to "translate" them so that I can create the same tables in a MySQL database.

Any help is appreciated.

Thanks.

 

[vacunita]

Have you looked into the MYSQL documentation?

Compare the format of the Create statements there to SQL's statement.

Technically speaking, unless the create statements are making use of some specific SQL functions, they should be generic enough to run. But of course you'd need to attempt to run them to see if they get caught up somewhere.

Try posting an example we can tell you if its vanilla enough to run.

Otherwise the mysql online manual is your friend.

http://dev.mysql.com/doc/refman/5.1/en/create-table.html

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Behind the Web, Tips and Tricks for Web Development.

http://behindtheweb.blogspot.com/

 

[sebes]

As is, SQL server scripts won't run.

It's not hard but...I still have to do some reading.

Thanks.

 

[feherke]

Hi

won't run.

That not helps us to help you. Please describe what it does instead of running. Paste the error messages and the script lines which generated them.


Feherke.

http://free.rootshell.be/~feherke/

 

[sebes]

Well, for now I don't need more help. Thanks.

I'm running them already. Here's what I've found so far:

1. MySQL scripts need a semicolon at the end of each line
2. Accepted default value for DATETIME type is 0(zero) NOT ""
3. Many of my SQL server tables have rows too long to be accepted in MySQL. BTW I don't know what the MySQL limit is or why there is a limit...

Hope this helps.

-gl