Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2004-03-31 : 20:20:37
|
| Ok, I'm not even going to rant about why DB vendors can't get their act together and support ANSI (and fix ANSI where it has limitations). It's not going to happen, so I'm going to have to live with that.So does anyone know of an automated way to translate scripts between, say, MySQL and MS SQL. Like, for instance, if you have a MySQL script to create 100 or so tables and need to run it against MS SQL? I realize that there are ways to transfer an existing schema from one to the other, but I'm hoping for something to parse and adjust scripts.Thanks-b |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-31 : 20:45:18
|
Nope, but if you find it can you let me know. I could use it. MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-04-01 : 08:41:43
|
| Bitch at the MySQL people, there's just as many if not more deviations from ANSI in their product as there are in SQL Server. |
|
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2004-04-02 : 13:33:31
|
quote:
Originally posted by robvolk
Bitch at the MySQL people, there's just as many if not more deviations from ANSI in their product as there are in SQL Server.
Hey now, no need to be defensive. I blame everyone. And I have bitched at them to, but thought that a MySQL mailing list was a more appropriate place.Cheers-b |
|
|
|
|
|
|
|
|
Translate MySQL queries?