Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Initial Programming Considerations : Database design issues

Database design issues

When you create or modify the OpenEdge databases or MS SQL Server databases that your applications access, you must consider general database design issues such as OpenEdge and MS SQL Server database objects, naming conventions, code pages, indexes, and data types. The following sections describe how OpenEdge databases and MS SQL Server databases differ in such areas and how the DataServer resolves the differences.
* OpenEdge database objects and MS SQL Server database objects
* Naming conventions
* MS SQL Server DataServer data source limits
* Code pages
* Support for Unicode
* Indexes and sorting
* Case-sensitivity
* Interaction of code page, collation, and case sensitivity
* Initial value
* MS SQL Server data source views
* Triggers
* OpenEdge sequences