RE: Can you convert a MS Sql database to MySQL?
See also: http://www.kofler.cc/mysql/mssql2mysql.html mssql2mysql converts Microsoft SQL Server databases to MySQL (schema + data, but no SPs, no triggers, no views etc.) mssql2mysql is VB/VBA code (you need VB6 or a VBA6 capable program such as Excel 2000 or Word 2000 to run it) mssql2mysql is free (GPL) Best wishes, Michael Kofler http://www.kofler.cc - 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
Re: Can you convert a MS Sql database to MySQL?
You can use MS SQL's Scripting tool to produce the table structure, but MS SQL's scripts need to be massaged a bit before you can use them with MySQL to create the database. The data is another story. MS discontinued the 'DUMP' command after SQL Server 6.5 (it is in 7.0 for backward compatability), but I have never been happy with the results. There are other approaches you can take (export to CSV file, etc.), but again, the results leave something to be desired. The only way I have been able to get the data from MS to MySQL is via Access, using the 'Link Tables' option. If you have enough time and programming talent, you could write an app to do the job, but I know of none. G. Jensen - Original Message - From: "Chris Harshman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 14, 2001 10:22 AM Subject: Re: Can you convert a MS Sql database to MySQL? > > Can't MS SQL export to an "SQL Script?" I imagine it would be a simple > matter of cat'ing said script and piping it into the MySQL CLI client. > (Are you on a UNIX box?) > > > On Fri, 13 Apr 2001, AJ wrote: > > > > > Does anyone know any good source of info for the conversion of MS Sql > > databases to MySql? Perhaps a prog that does this? Thanks for any > > information in advance, > > > > AJ Workman > > > > > > - > > 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 > > > > > - > 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 > - 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
Re: Can you convert a MS Sql database to MySQL?
Can't MS SQL export to an "SQL Script?" I imagine it would be a simple matter of cat'ing said script and piping it into the MySQL CLI client. (Are you on a UNIX box?) On Fri, 13 Apr 2001, AJ wrote: > > Does anyone know any good source of info for the conversion of MS Sql > databases to MySql? Perhaps a prog that does this? Thanks for any > information in advance, > > AJ Workman > > > - > 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 > - 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
Re: Can you convert a MS Sql database to MySQL?
Actually, we are looking to do just the same thing for a pretty large database. We've come across a project at sourceforge that claims to do this (upsize bcp) and will be investigating how well it works next week. Sourceforge page is http://sourceforge.net/projects/upsize-bcp/. On Fri, 13 Apr 2001, AJ wrote: > Does anyone know any good source of info for the conversion of MS Sql > databases to MySql? Perhaps a prog that does this? Thanks for any > information in advance, > > AJ Workman > > > - > 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 > - 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
Re: Can you convert a MS Sql database to MySQL?
AJ, In the past, I have used ACCESS ODBC to create an Update Query to move data between Access and MySQL. My stuff was small so I did it by hand. Andy AJ cc: Subject: Can you convert a MS Sql database to MySQL? 04/13/2001 11:58 PM Does anyone know any good source of info for the conversion of MS Sql databases to MySql? Perhaps a prog that does this? Thanks for any information in advance, AJ Workman - 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 - 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
Can you convert a MS Sql database to MySQL?
Does anyone know any good source of info for the conversion of MS Sql databases to MySql? Perhaps a prog that does this? Thanks for any information in advance, AJ Workman - 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