admin writes: > I am working on a project for a client that got roped into MsSQL7 by her > last hosting company. I am looking for a good way to convert a MsSQL7 > Database to MySQL. Anyone know of a piece of software that will convert the > Database files or atleast suck from one database to the another. > > Thanks in advance.
Hi, Create first the tables in MySQL. If possible, dump the table definitions from MsSQL into .sql files and read with 'mysql' command line client. Export (dump) the data from the tables in MsSQL7 into text files, for example into tab delimeted text files. Import to MySQL with mysqlimport. Regards, - Jani For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Jani Tolonen <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
