The Generate delta.sql utility allows you to migrate schema changes from an OpenEdge database to an MS SQL Server database. The utility reads a delta.df file that has been created using the incremental dump procedure and creates a new file containing SQL DDL for updating the .df file which can then be used to complete the migration process.

By default, the Map to MSS Datetime Type option is checked. Uncheck the box to map MS SQL Server 2008 data types to ABL DATE, DATETIME, and DATETIME-TZ data types:



Note: An extent field can not be modified without being dropped. If you are modifying and extent field in an OpenEdge Database while generating a Delta.df, the Delta SQL utility generates a Delta.df file contains corresponding Drop and ADD statements for the field. Data in the old extent field will be lost as the Delta SQL utility will replace the existing extent field.