The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

  DateTime Here

Trailing Spaces in SQL Server

Because it's different between Oracle and SQL Server, and when you convert from one to the other, you will care.

https://www.brentozar.com/archive/2017/04/surprising-behavior-trailing-spaces/

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:59852033114407 

Is there any way of forcing SSMA to retain the trailing spaces on migration? NO, see link below !!!!

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/95e814b6-ab47-4278-8fc5-7fdb73170999/oracle-sql-migration-ssma-trimming-trailing-spaces?forum=sqlservermigration

Trailing Spaces in PRIMARY KEY Columns - Oracle to SQL Server Migration

http://www.sqlines.com/oracle/trailing_spaces_pk_columns

 


Blog Home