Progress
DataServer for
Microsoft SQL Server
Guide


Preparing a Data Source for the Utility

The Progress-to-MSS migration utility translates definitions for Progress objects into an SQL DDL script to load into your target data source. It automatically makes adjustments in the target data source in order to provide the functionality of the Progress and target systems.

When you use the Progress-to-MSS utility to make a SQL Server™ database compatible, it converts arrays by using one column in the SQL Server™ database for each extent of the Progress array. The utility generates names for the columns that it adds to a table in a target data source using the format field–name##extent–number. For example, a Progress field called monthly–amount with an extent of 12 will have 12 columns in the data source with names such as MONTHLY_AMOUNT##1 through MONTHLY_AMOUNT##12.


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