Mickael, DTS comes with MS SQL's Enterprise Manager. And yes, DTS will create the tables, etc. for you. It does a bad job of some things during the export. For example, I would check the properties of fields that were designated as primary keys or are ID fields and make sure that they are so after the export.
If you really want to be careful, export the structure of the mySQL database (tables, etc) to a text file (DDL) and then run the DDL script using Enterprise Manager's Query Analyzer. Make sure that the tables are designated as owned by the dbo, if that is important to you. Then use DTS to import the data. Note that this way will take a far longer time and effort from you, since you will have to make sure that all the incoming fields (from mySQL) line up with those in SQL Server. DTS will try to line up whatever it things are right, but sometimes it gets things wrong. George 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 > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:211049 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
