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:
- Run a SQL script to make changes to the SQL Server™ database.
- Run the Update/Add Table Definitions utility on one schema holder.
- Recompile code against the updated schema holder to build new r-code.
- Send out copies of the new
.r
files to your users.- 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 |