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 : Update/Add Table definitions utility
 
Update/Add Table definitions utility
The Update/Add Table Definitions utility allows you to pull definitions from a table in a foreign data source. The table may be new or already exist in the schema holder, in which case you can add definitions or update definitions that are outdated. By default, MS SQL Server DATETIME and SMALLDATETIME data types are mapped to the OpenEdge DATE data type. The utility allows you to change the mapping to OpenEdge DATETIME.
Note: Since time zone support is new in 10.2B, any DATETIMEOFFSET column pulled from an MSS SQL Server 2008 or later database is automatically mapped to DATETIME-TZ by default.