>I'm not sure ODBC drivers exist for MySQL. Although I work with both >platforms, I've never had a need to connect a SQL Server database to a MySQL >database.
As others have suggested, by far the simplest way to do this is to download the ODBC drivers from the MySQL web site. Install those on your WIndows box (you don't even have to have MySQL installed on the box you're using to facilitate the transfer), set up an system ODBC datasource that points to the MySQL database, and then fire up Enterprise Manager and use DTS. I just did this exact this on a database last night. Couple of things to note: 1. Double-check the field lengths for varchar datatypes. Mine all came out wacky on the SQL Server side, so just check them before you run the DTS job. 2. At least when I did this, SQL Server does not retain the primary keys as defined in MySQL, so you just have to go in and define those after you run the DTS (at least that's what I did). Other than those two minor issues I had no troubles! Matt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205732 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
