Sample Header Ad - 728x90

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