1
Bugs and Issues / SQL Server DB Trimming Association Source and Target to 50 Characters
« on: October 27, 2016, 02:21:00 am »
All,
We recently transitioned from Oracle to SQL Server 2012 to help with performance issues. Shortly after this, we realized that all of our Association Source and Targets had been trimmed down to 50 characters.
This was not a problem in Oracle but is in SQL Server 2012. Is there something in the Schema that is causing this trimming? If so how can we fix it in the schema or will that break other things?
Any help would be greatly appreciated, SQL Server is much faster but we are forced to work in slow Oracle if this issue can't be fixed.
Thanks,
Sean Conway
We recently transitioned from Oracle to SQL Server 2012 to help with performance issues. Shortly after this, we realized that all of our Association Source and Targets had been trimmed down to 50 characters.
This was not a problem in Oracle but is in SQL Server 2012. Is there something in the Schema that is causing this trimming? If so how can we fix it in the schema or will that break other things?
Any help would be greatly appreciated, SQL Server is much faster but we are forced to work in slow Oracle if this issue can't be fixed.
Thanks,
Sean Conway