Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

> ## Preparing a data source for the utility

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

> When you use the Progress-to-MSS utility to make an MS SQL Server database compatible, it converts arrays by using one column in the MS SQL Server database for each extent of the OpenEdge 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, an OpenEdge 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095