MySQL Forums
Forum List  »  Microsoft SQL Server

Re: MSSQL to MySQL Data migration successfull but nothing copied/created
Posted by: Fred Nelson
Date: October 11, 2005 08:30AM

I found that if a certain data type is in the MS-SQL table then the table will not be converted. In my conversion any table that had the "SmallDateTime" data type was completely skipped - no rows were created in the MySql tables. The tables were created and populated where this "SmallDateTime" was not used.

Presenlty I'm trying to figure out what to convert the MS-SQL DateTime colums to so that the migration works.

It would be nice if the migration tool gave a warning and an explanation rather than running and producing no output.

When I solve the date conversion I'll make a post here!

Hope this helps!

Options: ReplyQuote


Subject
Written By
Posted
Re: MSSQL to MySQL Data migration successfull but nothing copied/created
October 11, 2005 08:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.