RE: SSMA to migrate data from oracle to sqlserver

SSC Guru

Points: 323504

April 29, 2014 at 11:12 am

in the SSMS grid, in order to force visibility of the data , for display purposes only,Carriage Returns and Line Feeds are turned into spaces; however the data truly still contains the original CrLf;

if you click Control+T (test mode) and rerun your query, you'll see the formatting.

SSMS is a utility,and not a real reporting tool;

the data exported to raw text, like delimited CV, would have your formatting; excel might show the CrLf, or it might hid eit as well; excel likes to format data it thinks it recognizes.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!