LifeAsBob - Blog
Home
Recent PostsCrowdstrike BSOD reboots corrupts PowerBI Config filesAJ Graduation 2024No posts for 1 yearVisual Studio IIS Debug web projectIIS NT Authentication Stopped workingRemove SMO - Parse for GOSQL Server Management Studio MFA hanging not promptingHonda CTX 700 2014Postgres to SQL Quick TipsStored procedure can not return BIGINT
Popular PostsSQL Server Management Studio MFA hanging not promptingLoblolly Pine TreesSQL Server Drop Constraints unknown nameGrant Create Table Permissions to a Schema, but not DBOIIS NT Authentication Stopped working
Recent PostsJuly, 2024-7,(1)May, 2024-5,(2)May, 2023-5,(1)February, 2023-2,(1)November, 2022-11,(1)July, 2022-7,(2)March, 2022-3,(1)November, 2021-11,(2)August, 2021-8,(2)July, 2021-7,(2)June, 2021-6,(1)May, 2021-5,(1)March, 2021-3,(1)February, 2021-2,(2)January, 2021-1,(7)December, 2020-12,(3)March, 2020-3,(2)February, 2020-2,(1)December, 2019-12,(2)November, 2019-11,(1)October, 2019-10,(1)September, 2019-9,(1)August, 2019-8,(1)May, 2019-5,(1)April, 2019-4,(2)March, 2019-3,(2)December, 2018-12,(1)November, 2018-11,(4)July, 2018-7,(1)May, 2018-5,(3)April, 2018-4,(2)February, 2018-2,(3)January, 2018-1,(3)November, 2017-11,(2)August, 2017-8,(1)June, 2017-6,(3)May, 2017-5,(5)February, 2017-2,(1)December, 2016-12,(1)October, 2016-10,(2)September, 2016-9,(1)August, 2016-8,(1)July, 2016-7,(1)March, 2016-3,(2)February, 2016-2,(3)December, 2015-12,(5)November, 2015-11,(5)September, 2015-9,(1)August, 2015-8,(2)July, 2015-7,(1)March, 2015-3,(2)February, 2015-2,(1)December, 2014-12,(4)July, 2014-7,(2)June, 2014-6,(2)May, 2014-5,(3)April, 2014-4,(3)March, 2014-3,(1)December, 2013-12,(2)November, 2013-11,(1)July, 2013-7,(1)June, 2013-6,(2)May, 2013-5,(1)March, 2013-3,(3)February, 2013-2,(3)January, 2013-1,(1)December, 2012-12,(3)November, 2012-11,(1)October, 2012-10,(1)September, 2012-9,(1)August, 2012-8,(1)July, 2012-7,(6)June, 2012-6,(1)April, 2012-4,(1)March, 2012-3,(3)February, 2012-2,(3)January, 2012-1,(4)December, 2011-12,(3)October, 2011-10,(3)September, 2011-9,(1)August, 2011-8,(10)July, 2011-7,(2)June, 2011-6,(7)March, 2011-3,(2)February, 2011-2,(3)January, 2011-1,(1)September, 2010-9,(1)August, 2010-8,(2)June, 2010-6,(1)May, 2010-5,(1)April, 2010-4,(3)March, 2010-3,(2)February, 2010-2,(3)January, 2010-1,(1)December, 2009-12,(3)November, 2009-11,(3)October, 2009-10,(2)September, 2009-9,(5)August, 2009-8,(3)July, 2009-7,(9)June, 2009-6,(2)May, 2009-5,(2)April, 2009-4,(9)March, 2009-3,(6)February, 2009-2,(4)January, 2009-1,(10)December, 2008-12,(5)November, 2008-11,(5)October, 2008-10,(13)September, 2008-9,(10)August, 2008-8,(7)July, 2008-7,(8)June, 2008-6,(12)May, 2008-5,(14)April, 2008-4,(12)March, 2008-3,(17)February, 2008-2,(10)January, 2008-1,(16)December, 2007-12,(6)November, 2007-11,(4)
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
http://www.sqlines.com/oracle/trailing_spaces_pk_columns