Hi George, I have never used DTS. Will it with DTS create the Tables and structure for me automatically? Or do I need create all the tables first? ----- Original Message ----- From: "George Abraham" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> 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 the tables and the data. > > HTH, > George > > On 7/1/05, Mickael <[EMAIL PROTECTED]> wrote: > > 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 = > > MySQL database to another. Is there an easy way to do this in CF? I = > > have the MySQL DSN setup and the MSSQL DSN setup on the same box? > > > > I have have seen a lot of utilities out there for MySQL to Access. My = > > issue is that the database needs to have more than 255 fields Access = > > does not support more than 255 fields. > > > > Thanks > > > > > > > > Mike Elmalem > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211038 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
