Thanks I will try that. ----- Original Message ----- From: "George Abraham" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> 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. 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:211095 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
