Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Translate SQL Server scripts into MySQL
- Thread starter sebes
- Start date
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.
----------------------------------
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.
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.
----------------------------------
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.
- Thread starter
- #3
Hi
Feherke.
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.sebes said:
Feherke.
- Thread starter
- #5
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
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
- Status