Re: OT - MySQL to MSSQL

2005-07-04 Thread Mickael
Thanks I will try that. - Original Message - From: George Abraham [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, July 01, 2005 2:36 PM Subject: Re: OT - MySQL to MSSQL Mickael, DTS comes with MS SQL's Enterprise Manager. And yes, DTS will create the tables, etc

OT - MySQL to MSSQL

2005-07-01 Thread Mickael
Hi All, I was wondering if someone can point me to the best way to import a = MySQL Database to a new MS SQL Database. There is an export utility in = MySQL that exports that tables to a text file with the create table = statements and all the content. But I think this only works from One =

Re: OT - MySQL to MSSQL

2005-07-01 Thread George Abraham
I did this a long time ago, but if I remember correctly, all you need are the mySQL ODBC driver and MS SQL Server's Enterprise Manager. Install the ODBC driver, then use DTS in Enterprise Manager to transfer the tables and the data. HTH, George On 7/1/05, Mickael [EMAIL PROTECTED] wrote: Hi

RE: OT - MySQL to MSSQL

2005-07-01 Thread Mark A Kruger
MIke, Use DTS and your ODBC DSN to pull over the data. You will probably have to set up the a few things after the import. -mark -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Friday, July 01, 2005 8:52 AM To: CF-Talk Subject: OT - MySQL to MSSQL Hi All, I

Re: OT - MySQL to MSSQL

2005-07-01 Thread Mickael
Subject: Re: OT - MySQL to MSSQL I did this a long time ago, but if I remember correctly, all you need are the mySQL ODBC driver and MS SQL Server's Enterprise Manager. Install the ODBC driver, then use DTS in Enterprise Manager to transfer the tables and the data. HTH, George On 7/1/05

Re: OT - MySQL to MSSQL

2005-07-01 Thread Greg Morphis
-Talk cf-talk@houseoffusion.com Sent: Friday, July 01, 2005 10:56 AM Subject: Re: OT - MySQL to MSSQL I did this a long time ago, but if I remember correctly, all you need are the mySQL ODBC driver and MS SQL Server's Enterprise Manager. Install the ODBC driver, then use DTS in Enterprise

Re: OT - MySQL to MSSQL

2005-07-01 Thread George Abraham
@houseoffusion.com Sent: Friday, July 01, 2005 10:56 AM Subject: Re: OT - MySQL to MSSQL I did this a long time ago, but if I remember correctly, all you need are the mySQL ODBC driver and MS SQL Server's Enterprise Manager. Install the ODBC driver, then use DTS in Enterprise Manager to transfer