Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nivarshn
Starting Member
5 Posts |
 Posted - 2014-04-29 : 13:07:14
|
| We migrated data from oracle to sqlserver using SSMA but when we see data of sqlserver on .NET GUI, formatting is different than oracle data display on .NET GUI.For an example we are able to see data of oracle on .NET GUI of a spectific column of grid :HelloHow are you ?But in sql server all data is displaying in single line like :Hello How are you ?We executed below command on sql server but still able to see data in single row : update table_name set column_name =replace(column_name,'\n',char(13)+char(10))Can you please provide us solution as soon as possible ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-04-29 : 13:14:59
|
| This is an application issue. You will need to take a look at the .NET code and make proper adjustments. Perhaps it's a database driver issue, perhaps it's a simple formatting issue, not sure.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
nivarshn
Starting Member
5 Posts |
Posted - 2014-04-29 : 21:46:11
|
| I had already checked , it is not an application issue.we are using collation as Latin1_General_Bin in sqlserver. Is it the cause ?When we run query of oracle in sql developer and paste the output of specific column in notepad++, it shows the LF character butsame out put of sqlserver does not show LF character in notepad++.Still I am not able to find out the root cause why LF character is not shown in sqlserver, we migrated the data using SSMA from oracle to sqlserver .Will we have to do some setting change in SSMA while migrating data of varchar column ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-04-30 : 12:01:21
|
| I would suggest opening a case with Microsoft.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Migrate data from oracle to sqlserver using SSMA