The only documented approach to migrate is a dump and load of the Dataserver schema
Below are the instructions to migrate the dataserver schema between 10.2B and 11.x. The same applies for the migration between 2 major releases:
In OE 10.2B Data Administration Tool:
- Connect to the schema holder, then the dataserver schema
- Dump the dataserver schema
In OE 11.x Data ADministration Tool:
- Create a new schema holder, make sure the code page match the codepage of the schema holder in OE 10.2B
- Go to "DataServer" > "MS SQL Server Utilities" > "Create DataServer schema"
- Fill-in the dialog with the appropriate information. You may open the 10.2B .df generated so the information can match, regarding the codepage, collation, case sensitivity
- Press OK
If the connection is successfull you will be prompted to select the tables to pull to the schema: PRESS CANCEL
This will generate an empty DataServer schema with only the header information.
- Edit the .df generated in 10.2B and remove the header information.
- Save the .df
- Back to the Data Administration, make sure you that the currently working db is the dataserver schema (The top left corner of the windows should read "Database: <logical name> (MSS)").
- Go to "Admin" > "Load Data and Definitions" > "Table contents"
- In the dialog select the 10.2B header-less .df you have previously edited.
These are examples of header:
/* HEADER FOR OPENEDGE 10.2B */
ADD DATABASE "DBNameInDataServerSchema" TYPE MSS
DBNAME "DBNameOnMSSQL"
DB-MISC11 1
DRIVER-NAME "SQLSRV32.DLL"
DRIVER-VERS "03.85.1117"
ESCAPE-CHAR " """
DRIVER-CHARS "3,13,14,17,20,23,33,35,36,"
DBMS-VERSION "Microsoft SQL Server 08.00.0760"
DSRVR-VERSION "03.52.0000"
PROGRESS-VERSION "Dictionary Ver#: 1.000.000 Client Ver#: 101.00,(sh_min=1,sh_max=2); Server Ver# 101.00"
DSRVR-MISC "Microsoft SQL Server"
CODEPAGE-NAME "ISO8859-1"
COLLATION-NAME "Basic" 
