SQL Server DB Trimming Association Source and Target to 50 Characters

[localhro2]

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

[qwerty]

I think that in the past you had modified the schema for Oracle since that also limits quite some fields to 50 chars. Just look into the : schema scripts. So you need to make the SQL Server scripts look like the one you deployed on your Oracle.

q.