Re: Data Migration from SQL Server 2014
Hi,
Try this way: run migration wizard, select source and target databases. On 'Target Creation Options' step make sure that 'Create schema in target RDBMS' option is unchecked. Then in 'Data Transfer Seup' step uncheck 'Online copy of table data to target RDBMS' and check 'Create a shell script to copy data from outside Workbench'.
Edit generated script, write password for source and target RDBMS and replace your column like this: CAST([hasGroupsRestrictions] as TINYINT(1)) as [hasGroupsRestrictions] or CAST([hasGroupsRestrictions] as TINYINT) as [hasGroupsRestrictions] and execute it.
--
Milosz Bodzek
MySQL Developer Tools
Subject
Views
Written By
Posted
2337
January 26, 2015 11:34AM
Re: Data Migration from SQL Server 2014
771
January 28, 2015 03:05AM
704
January 28, 2015 04:14AM
623
January 29, 2015 02:27AM
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.