Sunday, April 15, 2012

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.

6 comments:

  1. This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
    healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
    Solutions for all Industries,
    Getting your applications talking is the key to better business processes,
    Rapid web services solutions for real business problems,
    Web-based Corporate Document Management System,
    Outsourcing Solution,
    Financial and Operations Business Intelligence Solution,

    ReplyDelete
  2. It is very useful fro me, as i do not have any idea about Progress to SQL Migration.
    But I have a question - How to achieve incremental data from Progress to SQL 2012 on daily basis

    ReplyDelete
    Replies
    1. Thanks for your comment, as far as I know there is issues with the driver and sometimes it didn't handle data types properly, So I didn't think this migration on daily basis is handy.

      Delete
  3. I appreciate your great work. Thanks for sharing. Keep me more update in future.

    Ie8 to Ie11 Upgrade
    Windows Migrations

    ReplyDelete
  4. Good information about DB migration. Now many technology is outdated, we need to migrate the service.

    Microsoft Access to SQL Server Migration

    ReplyDelete
  5. Hi guys,
    Thank you so much for this wonderful article really!
    If someone want to know more about the
    migrate cloud data
    I think this is the right place for you!

    ReplyDelete

Card