Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
The DataServer Tutorial : Delta df to MS SQL Server Incremental Schema Migration utility
 

Delta df to MS SQL Server Incremental Schema Migration utility

The Incremental Schema Migration utility allows you to migrate schema changes from OpenEdge to a MS SQL Server database. For example, in the process of developing an application in ABL that you will migrate to MS SQL Server, you might want to make and test schema changes in the OpenEdge database that you want reflected in the MS SQL Server database. The utility reads an OpenEdge delta.df file that has been created using the standard incremental dump procedure. and creates a delta.sql file that contains the SQL DDL for making the changes and a delta.df file. You can then load the delta.df file into the schema holder. You can then apply the delta.sql file to the MS SQL Server database to complete the migration process.
Note: You do not make schema changes directly in the schema holder, which must remain synchronized with the MS SQL Server database. The utility uses the schema holder to determine what the MS SQL Server definitions are.
The following sections discuss how you can perform schema pull interactively or silently (that is, in batch mode).
* Running the Incremental Schema Migration utility interactively
* Running the Incremental Schema Migration utility silently (batch mode)
* Adjusting field widths during migration
* Updating the MS SQL Server database