I need to migrate numerous web sites from MySQL 4.0 to SQL Server. My datatypes and queries are all pretty simple, except that I make use of auto_increment columns. This should be fine since SQL Server supports the identity property, but I'm having some difficulty using DTS to migrate the data.
Part of the annoyance is that DTS seems to ignore field width definitions for varchars... ie, a varchar(255) in mysql gets changed to varchar(x) where X is the largest current value in that field. Easy enough to work around because I can edit the SQL during the data transformation process. DTS also seems to think that mysql "int(11)" fields should be "decimal" in SQL Server. Again, easy enough to fix. My problem is with the auto_increment columns. I edit my CREATE statement to set the identity property, and the create works fine but the data load fails. Has anyone had any experience migrating this kind of data from MySQL to SQL Server, and maybe offer up some tips? Thanks. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219170 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
