The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Modified field sizes
Posted: 07 Jan 08 4:57 PM
|
Getting ready to upgrade from 6.2.3 to 7.2.1 and it suddenly occured to me that our previous business partner might have changed field sizes on system tables (they were very creative.) Anyone have a query that will allow me to check that all fields in the DB are the same size after the upgrade (dev DB) that they were before the upgrade (current production?)
I tried to return the table name and field names from sysobjects and syscolumns but I can't join the two DBs on a compound key of table name and field name. 
Thanks for any help you can send my way.
Michael |
|
|
|
Re: Modified field sizes
Posted: 09 Jan 08 7:00 AM
|
By "System Tables" you mean SalesLogix Tables.. right?
The only reason a partner may have done this (and most of us have at one time or another) was to solve a business problem where the length of a field was too short for typical (customer) data.
I'd leave it alone and just upgrade.
--
RJLedger - rjlSystems |
|
|
|
Re: Modified field sizes
Posted: 09 Jan 08 7:00 AM
|
By "System Tables" you mean SalesLogix Tables.. right?
The only reason a partner may have done this (and most of us have at one time or another) was to solve a business problem where the length of a field was too short for typical (customer) data.
I'd leave it alone and just upgrade.
--
RJLedger - rjlSystems |
|
|
|
Re: Modified field sizes
Posted: 10 Jan 08 3:02 AM
|
I am not sure if you realy need to bother with that, but if you do you might try using a tool like DB Compare (Google it). Back up a copy of the DB prior to upgrade, then restore it on a diferent server or on the same server as a different named database and compare the pre and post upgrade versions.
Hope that helps |
|
|
|