TEXT data migrate from Sybase to SQL Server
4
votes
2
answers
915
views
I'm working on migrating Sybase ASE 15.7 SP134 database to SQL Server 2008R2, using SSMA for Sybase 2014.
I'm facing an issue where a table in SybaseDB has 2 columns with the data type
TEXT
. The SQL Server table with datatype "text" is mismatching on Japanese data characters.
Questions are:
1. How can we keep same text as Sybase while migrating data?
2. How to keep Non-ASCII characters as it is during migration?
Please comment if more information can be provided.
Asked by Im88
(326 rep)
Sep 26, 2017, 05:44 PM
Last activity: Sep 27, 2017, 06:17 PM
Last activity: Sep 27, 2017, 06:17 PM