Data Migration from SQL Server 2014
While migrating data from SQL 2014 receiving following error in to table we are receiving following error on many columns of different tables
Type mismatch fetching field 30 (should be short, was MYSQL_TYPE_TINY)
DataType in MySQL for column
`hasGroupsRestrictions` tinyint(1) NOT NULL DEFAULT '0',
DataType in SQL 2014
[hasGroupsRestrictions] [smallint] NOT NULL DEFAULT ((0)),
Note: I cannot change the datatype in MySQL of this column as Schema is already created and client don't want to change datatypes but I can change of SQL 2014.
Please help me out on this.
Subject
Views
Written By
Posted
Data Migration from SQL Server 2014
2352
January 26, 2015 11:34AM
779
January 28, 2015 03:05AM
710
January 28, 2015 04:14AM
629
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.