Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Initial Programming Considerations : Data types : DataServer for MS SQL Server support for datetime data types : Generate delta.sql OpenEdge to MS SQL Server utility
 
Generate delta.sql OpenEdge to MS SQL Server utility
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.