Progress DB Migration

The purpose of this article is to guide you through step by step procedure on how to migrate from progress DB to access DB or to any other DBMS.

Progress DB Migration:

Database Migration is a process of moving or coping data from one database management system (DBMS) to another or moving data from an old system to another for example moving/coping data from Progress DB to SQL Server or to Access and so on.

Key Concepts:

Legacy Database: is an old database management system (for more Info. http://esj.com/articles/2007/11/06/why-legacy-databases-are-here-to-stay.aspx)

File system: is a file that created by an application to contain needed information for the application, for example you can create a file loaded when your application is startup to get configuration. Some existing applications produce files (like text file, or CSV (Comma Separated Value) file) like many Telecom applications, and some figure print devices and so on.

Data Cleansing: is a process of preparing data from legacy system to be included in the new system. (for more Info. http://www.infotechnet.org/ntca/DataMigration.htm )

ETL: Is a process of extracting data from database management system (or file system) and transforming this data in a proper format and loading it in the new Database management system (or file system) (for more Info http://en.wikipedia.org/wiki/Extract,_transform,_load )

Migrate from Progress DB to Access DB:

When I tried to migrate from Progress DB to Access I face problem on the driver I didn’t found any build-in driver to connect between progress and Access so I made search about ODBC drivers for progress, fortunately I found many, one of these is OpenLink (http://www.openlinksw.com/ ) so after installing and testing this tool it is really good tool.

Configuring OpenLink:

After installing OpenLink software:

1.       Go to Control Panel -> Administrative Tools -> Data Sources (ODBC).

2.       Choose System DSN tab.

3.       Press Add then you found many OpenLink Choose the appropriate one for you and double click on it.

4.       Name it, press next.

5.       Fill the fields as appear on figures bellow.

6.       Then press Finish.

Now your OpenLink has been configured.

Then access:

1.       Create new database.

2.       Go to insert, choose table.

3.       Select import table.

4.       Choose ODBC.

5.       Select Machine Data Source.

6.       Select your OpenLink created connection.

7.       Enter user name and password.

8.       Select tables to import.

 

 

 

 

If you want to migrate to SQL server you can migrate by using Export/Import wizard or by using SSIS, Sometimes there are problems with .Net framework regarding data types (which I faced and I googled but all I found does not help) so you may migrate to access and see what you can do.

For excel you will be faced by number of rows limitation problem.

Written By:

                       Elmozamil Elamir Hamid.