Data Migration in Progress Open Edge

[nszczepanski]

We have a task to migrate data from Progress OpenEdge 9 DB to a Progress OpenEdge 10 DB. We have tried to use the Progress 9 ODBC and it fails miserably in this ancient DB. Does anyone here know of the best way we can migrate data from one Progress DB to another. Any tools you recommend that could help? I have looked at the OpenEdge Evaluation Kit. We also looked at migrating to SQL Server 2008 then to Progress 10.

There has to be an easy way to do this. Any advice is welcomed. Thanks.

 

[jdpjamesp]

Moving from Progress v9 to Openedge is simple. There is a database upgrade tool provided by Progress. You may well want to do other things such as moving to Type II storage areas at this point though. I will move this post to a different forum so that people who are more qualified can give you advice

 

[cj_brandt]

Are you trying to pull data from a Progress version 9 database to a separate OE version 10 database ?
or
Are you trying to upgrade a Progress version 9 database to an OE version 10 database ?

 

[nszczepanski]

I am trying to pull data from a Progress 9 DB with hundreds of modifications in our ERP (QAD) and move the data to our newer version of our ERP that is on OE 10. We have hooks built into our OE 10 DB from SQL Server so if we can get the data from Progress 9 into SQL Server we will be good. Or if there is a way to migrate the data straight into OE 10 from Progress 9 with mapping capabilities we will be good.

We can't upgrade because of our modifications.

Are you trying to pull data from a Progress version 9 database to a separate OE version 10 database ?
or
Are you trying to upgrade a Progress version 9 database to an OE version 10 database ?

 

[Rob Fitzpatrick]

We can't upgrade because of our modifications.

Can you elaborate on these modifications? I assume you are referring to application modifications. If so, I'm not sure why that matters.

A Progress database is a Progress database. You should be able to upgrade it from 9 to 10. Or, preferably, you could create an empty V10 database with a Type II structure, load your schema, users (if any), and sequence values (if any), then relocate your storage objects (if required) and dump and load your data into it.

 

[cj_brandt]

You are asking for an ETL tool - something to extract the data, transform it and then load it into a target database. I am guessing the schema doesn't match between the version 9 and version 10 database ?

So do you have a 4gl or results license that allows you to write code ? If so this task is accomplished by using code to extract the data, use the code to modify the data and then write it out to an ASCII file.

It would be helpful to give a reason why you "Can't" do things like upgrade a database or use SQL to extract data. These things are done by many people.

 

[nszczepanski]

Yes I have to transform the data as the DB schema does not match. The modifications are application mods but there are added tables and the schemas don't match. I have tried to do the data dump in Progress by going into progress editor go to Tools on menu, then Admin then Data Dump but the data is not formatted correctly. I am no Progress programmer but I do know SQL, RPG on the AS/400, Java, and C#.NET. I can get the data dump to more familiar environment but it will take some work to reformat it and remap either with an ETL (I have Cognos and I have Business Objects tools) or a bunch of conversion programming. I went on here to see if there was an easier way or some ETL tool Progress had to do data transformations but it appears there isn't much in that way. The ODBC drivers for Progress 9 are beyond use but OE 10 the ODBCs are much better. Looks like I'm going to have to do this the hard way........


Thanks for the help everyone.

You are asking for an ETL tool - something to extract the data, transform it and then load it into a target database. I am guessing the schema doesn't match between the version 9 and version 10 database ?

So do you have a 4gl or results license that allows you to write code ? If so this task is accomplished by using code to extract the data, use the code to modify the data and then write it out to an ASCII file.

It would be helpful to give a reason why you "Can't" do things like upgrade a database or use SQL to extract data. These things are done by many people.

 

[nszczepanski]

This is interesting and sounds like it might work. Is there some documentation you can point me to that shows how to do this? Also, if I can get to OE10 I can then use the ODBC and the ETL tools I have.

You should be able to upgrade it from 9 to 10. Or, preferably, you could create an empty V10 database with a Type II structure, load your schema, users (if any), and sequence values (if any), then relocate your storage objects (if required) and dump and load your data into it.