Josh Chamas wrote: > Ryan Stille wrote: >> Has anyone ever used this MSSQL-to-MySQL converter? It's pretty >> reasonable at $40, and the demo output I got looked pretty good. But >> I wanted to see if there is anything I should be weary about. >> http://www.convert-in.com/mss2sql.htm >> > > I have done a test migration before with it and it seemed fine. > > I would also stay tuned for our MySQL Migration Toolkit to > support MSSQL migrations. You can find it here: > > http://www.mysql.com/products/tools/migration-toolkit/
I did go ahead and purchase the product. It worked pretty well, I had to modify the output a little. When exporting the data using this tool, it added ALTER TABLE lines that changed the DATETIME fields to DATE fields. I guess it saw that the time for all the dates was 0:00 and thought this information was not necessary. I did try the MySQL Migration Toolkit. Some of the definitions it generated were incorrect. One thing I remember for sure is that it was turning my TEXT(16) fields (which are pretty long) into VARCHAR(16), which is pretty short. But I understand it is still Alpha software. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]