Here is what has worked for me in the past when I migrate MS-SQL DBs to Postgres which is pretty similar to MySQL. Export out a script of your db structure using Enterprise Manager. Edit the script and remove any MS-SQL specific stuff. Find out which data types need to have different names (ex. int vs. integer) and do a find and replace on them then run the script on your MySQL box to create the table structures. Now go to your MS-SQL box and create an ODBC connection to your MySQL DB. Then use Enterprise Manager's export function (DTS) to push all of the data over to the new box. That is a very basic explanation, there will be some other things that you will need to figure out like if you have stored procedures, dates are usually different, and auto-incrementing id's. I hope that at least gets you started in the right direction.
Dave On Feb 2, 2006, at 7:01 AM, Katz, Dov B ((IT)) wrote: > You might want to consider using the "All Tasks->Export Data" from the > Enterprise manager in MSSQL and send the data to an ODBC datasource > you > can set up to point to your Mysql server. > > > > -----Original Message----- > From: Baz [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 02, 2006 6:01 AM > To: CF-Talk > Subject: Migrating app version 2.0 > > Hi, > > We just finished V2.0 of one of our client's apps, which included a > complete re-factoring of code from procedural to CFC, upgraded > functionality, and a significantly modified DB. > > Since the changes are major, we will be deploying the new app on a new > domain, and, once we're ready, we will switch the dns to there. > (rather > than just overwriting existing files on the existing domain) > > Everything seems easy enough except for the database part of it. Since > it was majorly changed, we will create a new MySQL5 DB on the new > domain, and migrate all the data from the current MS-SQL server. > > Does anyone have any tips, suggestions, gotchas for doing this? > Should I > do it through CF by creating scripts that query the old DB and > insert in > the new? How do I access a remote DB in CF? Are there better ways, > tools? > > Thanks for any help, > > Baz > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231118 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
