Progress
DataServer for
Microsoft SQL Server
Guide


Updating a Deployed Schema Holder

The guidelines and techniques that apply to deploying a Progress database also apply to deploying a schema holder for a SQL Server™ database. However, if you make any changes to the data source schema, make sure to update its schema holder. There are two techniques for updating a deployed schema holder:

Follow these general steps to update a deployed DataServer application:

  1. Run a SQL script to make changes to the SQL Server™ database.
  2. Run the Update/Add Table Definitions utility on one schema holder.
  3. Recompile code against the updated schema holder to build new r-code.
  4. Send out copies of the new .r files to your users.
  5. Distribute copies of the new schema holder .db and .bi files to your users. You must use the Progress PROCOPY utility to distribute them.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095