MSSQL to mySQL
Posted on 2003-12-11
I am trying to deploy my SQL server database to a web hosting vendor who uses mySQL.
I installed mySQL and myODBC, and use the DTS import/export wizard to create and run a package.
1, I get this error message: "... column 7 ('col_name', DBTYPE_STR) status 6 Data Overflow" with all of my tables. At the 'select source table and views' stage, if I select a table and click at the 'transform' button, I get to the 'column mapping and transformation' dialog. It shows that the size of all my 'varchar' as '-1'. Why? and how to correct this problem?
2, I see that the syntax of mySQL is completely different, e.g., [db].[dbo].[table1] -> `db`.`table1`, etc. Does this mean that I'll have to re-write all my stored procedures? AND I have to re-write my ASP.NET C# code?
3, I chose the destination of data as a "File DSN" instead of user/system DSN. Is that the right way to do it?
4, Is there an easier way to do this? (preferrably not having to purchase any software tools.)