If that doesnt work, Try the mysqldump command line utility. I believe the format is mysqldump -hHOST -pPORT -uUSER -pPASSWORD c:\mysql.sql
You may have to tweak the syntax, I'm not sure how close the 2 are. I used it to export and convert a DB to PostgreSQL, those 2 were rather similiar but had a few differences. On 7/1/05, Mickael <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211048 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
