I copied a big db from a mySQL db a couple of months ago. Go into Enterprise Manager and right-click on the DTS folder. All Tasks ---> Import Data. You get the wizard. First screen is Data Source. Click the Data Source tab and select the appropriate mySQL ODBC driver from the list. Your installed mySQL datasources will then appear in the User/System DSN dropdown. The rest should be just a few mouse clicks. Now this presupposes your desktop is running mySQL Server, and you have taken a moment to install an ODBC DSN onto that desktop, but really its a simple thing to install mySQL if you aren't, and the same goes for the ODBC drivers, and they are just as easy to remove. In exchange you get to use a wizard to migrate your data and you should have a pretty easy time of the field conversions. I will say I had a heck of a time with some decimal fields (they held lat/lon values along the lines of 12.34567), which I converted to varchar(mySQL) and then from nvarchar to decimal. Thing is since you are doing a wizard-based import you can just wipe what comes over and tweak it a bit as you go along. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com <http://mysecretbase.com>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:219182 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
