Progress
DataServer for
Microsoft SQL Server
Guide


Guidelines for Using the DataServer

Progress supports many capabilities not found in other database management systems, such as backward scrolling cursors and the ability to find the previous or last record in a table. The DataServer supports these and other programming and database features to ensure that your applications work with both Progress databases and SQL Server™ databases.

The DataServer allows you to use Progress features as extensions to your data source. Some of the Progress programming and database design techniques that you can implement on your MSS data source using the DataServer are:

For access to some of these features, you might have to make minor modifications to how your MSS data-source or application is organized. For a discussion of these issues and instructions for modifying your data source, see Programming Considerations."

If you create an MSS data-source from an existing Progress database with the Progress-to-MSS migration utility and select the Create RECID Field option, you can use the FIND PREV/LAST statements in addition to taking advantage of Progress-like cursor behavior.

How you use the DataServer depends on whether you plan to access information in a data source through a Progress application or migrate a Progress database to an MSS data source. The following sections summarize what you must do and point you to the information you need in this manual.


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