An application developed in the OpenEdge Studio can use the DataServer for MS SQL Server to access data from multiple sources transparently. With the DataServer, your applications can access information in both OpenEdge databases and MS SQL Server databases.
This chapter discusses fundamental considerations you need to know to plan your applications and design your databases. For example, you need to know the differences between OpenEdge databases and MS SQL Server databases, as well as the DataServer strategies for resolving these differences, which your application might need to accommodate.
Follow these initial guidelines carefully when you develop your application to ensure that it can access OpenEdge databases and MS SQL Server databases transparently. Once you are comfortable with this information, refer to the stored procedure details presented in
RDBMSStored Procedure Details, and the advanced guidelines in
Additional Features to Enhance DataServer Performance.
