Tormod, I feel your pain brother! Actually, I do this allot more than I'd prefer to admit.
I assume when you say MS SQL you mean SQL Server 2000. When you say MySQL, you mean MySQL 4.0.x. Scripting the database/tables from query analyzer doesn't produce files, which are immediately executable in MySQL - as you know. The reason being the syntax is a little different and more importantly SQL Server supports a number of features MySQL doesn't. Keep an eye on the dates. The format for dates in SQL (MM-DD-YYYY) is a different from MySQL (YYYY-MM-DD). My SQL wraps dates with single quotes while SQL Server uses hashes. If you're using referential integrity, try InnoDB or BDB tables versus MyISAM tables. Note, default values are constraints in SQL Server not in MySQL. No triggers or stored procs. Function names will change from sp_xxx to the mysql equivalent. Lots of security differences especially where user setup is concerned. Make sure you're security scripts account for user ID and host. To answer your question, there is a data base migration tool, which I've used to move DBs from <any_db> to Sybase's ASE. Not sure if it works for MySQL. To be honest, I just usually run through the script myself and make the necessary changes. If you run into any specific problems, shoot me a note. I might be able to help. Regards, Adam -----Original Message----- From: Tormod Halvorsen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 9:41 AM To: [EMAIL PROTECTED] Subject: Running a definition file from MS-SQL Hi all! (My apologies if this has been beaten to death allready, but I *did* search the archives without much luck.) I'm moving from MS SQL to MySQL. Before jumping from the old server, I scripted out the definitions for tables and their fields, thinking I might just run them into MySQL. Guess I need to edit the script some, because it keeps giving me a "Syntax error" message. Anyone know of a good source for info on how to make MS SQL scripts work on MySQL? I also have a copy of the database exported in MS Access format to hold the data - don't suppose it's any easier that way, uh? Thanks! peace, Tormod in Stockholm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
