Progress
DataServer for
Microsoft SQL Server
Guide


Programming Considerations

An application developed in the Progress Application Development Environment (ADE) can use the DataServer for SQL Server™ to access data from multiple sources transparently. With the DataServer, your applications can access information in both Progress databases and SQL Server™ databases. This chapter discusses the differences between Progress databases and SQL Server™ databases that you must consider when you plan your applications and design your databases, as well as the DataServer strategies for resolving these differences, which your application might need to accommodate. Specifically, it discusses the following topics:

Follow these guidelines carefully when you develop your application to ensure that it can access Progress databases and SQL Server™ databases transparently.

The material in this chapter is also of interest to users who plan to migrate a Progress database to an MSS data source. However, such a migration raises additional issues that you must consider when designing your application. For details, see the "Running the Progress-to-MSS Utility" section in The DataServer Tutorial."


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095