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
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 =
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
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
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
-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
@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
7 matches
Mail list logo