SQL Server: Extracting Data from OpenEdge Progress without OLE DB Driver


Importing data from OpenEdge’sProgress® data base is simple if you have OLE DB data provider. But if youdon’t have OLE DB driver or unable to configure it properly then there are fewsimple steps to migrate data from OpenEdge’s Progress® to SQL Server.
(Worst thing in Progress ®database I found that you can only restore your database from backup file withonly version with which this backup files was created i.e. you can’t restoreProgress 9.1 backup file on Progress 10 or newer version)
We will achieve our data migrationgoal through two step, first to import table structures and import data fromflat files to newly created tables.
Copying Table Structuer:
Once you have restored yourrequired backup file, you can access it from “Data Administrator” by connectingyour database file.
 Progress normally keep itsdatabases with extension “db” at installationdrive\Progress\WRK\YourDatabaseName.db
Once you are connected to yourdesired database, click on “ProgressDB to M SQL Server” through given path.
Provide necessary information forProgressDB to ODBC Conversion. Type any name of your choice for “Name of schemaholder database” and correct ODBC data source name.

On pressing OK button, it willcreate “.sql” file on “installation drive\Progress\WRK\”. This sql filecontains create table query for all database tables. Open this .sql file in SQLServer and create tables.

Extracting Data
In next step we will extract tabledata to CSV files.
Select table of your choice.
 Provide file name with target folderpath. Select “All (Max 255)” fields to export. You can provide WHERE clause tofilter output rows. Press OK button to proced
 Provide any record start string.It will add given string at start of each row. Which you can remove, once datais imported in SQL Server.
 Now you have tables structure anddata in text format. Execute simple Data Import process to import your desireddata from text files to already created tables.
Advertisements

Posted on July 25, 2011, in Data Migration, Sql Server 2005, Sql Server 2008. Bookmark the permalink. 1 Comment.

  1. My name is Matt and I work for Dell. Thank you so much for the information of SQL Server: Extracting Data from OpenEdge Progress without OLE DB Driver. I really liked your way of explanation through the images.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: