MySQL Forums
Forum List  »  MySQL Workbench

Re: Data Migration from SQL Server 2014
Posted by: Farhan Ahmed
Date: January 28, 2015 04:14AM

Hi Milosz,

Thanks for the response!!!!!! I will definatly check your solution.
But for now I have found another work around. I have set the global sql_mode to following


set global sql_mode='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

After that it is not giving any error. Although this will definatly truncate the data if size of data get bigger than the datatype defined on MySQL.

Anyways Thanks a lot !!!!

Please let me know how should I mark this topic as "Answered" or something?? :)

Regards
Farhan Ahmed

Options: ReplyQuote


Subject
Views
Written By
Posted
2329
January 26, 2015 11:34AM
Re: Data Migration from SQL Server 2014
700
January 28, 2015 04:14AM


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.