Kbase P102480: How to update V9 MSS DataServer schema contained in the schema holder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/16/2010 |
|
Status: Verified
GOAL:
How to update MSS DataServer schema contained in the schema holder
GOAL:
Is there any utility to update MSS DataServer schema in schema holder without doing a pull.
FACT(s) (Environment):
Progress 9.1x
MS SQL DataServer
All Supported Operating Systems
FIX:
In V9, the only way to update a schema holder after making changes to the schema in MS SQL Server is to use the MS SQL Server Add/Update Utility on one schema holder and dump the updated schema to create a df file. Then that df can be applied to all other schema holders for that MS SQL Server database which must be updated.