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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:211027 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
