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 : Enabling Datetime data types using the Data Administration tool
 
Enabling Datetime data types using the Data Administration tool
The OpenEdge Data Administration tool provides utilities for migrating an OpenEdge database to a MS SQL Server data source and for pulling definitions from an MS SQL Server data source into an OpenEdge database, referred to as a schema holder. In doing so, OpenEdge applications use the DataServer to access and update data stored in MS SQL Server data sources.
The Data Administration tool ensures that utilities can recognize and handle date time data types supported in starting in MS SQL Server 2008 and later. Those utilities include:
*Update/Add Table Definitions
*Verify Table Definitions
*Schema Migration > OpenEdge DB to MS SQL Server
*Adjust Schema
*Generate Delta.sql OpenEdge to MS SQL Server
*Dump as Create Table Statement