OpenEdge to MSSql Conversion ?

jacs

New Member
This may be a basic question, but I just am not that familiar with OpenEdge databases. I am going to run the OpenEdge to MS SQL Conversion tool which I know how to do, I just need to confirm that when I run this, even though it says Move Data, is it just creating a copy to MS SQL or is it actually moving the data. I need the data converted for an ERP Migration, but I do not need the OpenEdge database moved as a permanent as the current ERP system will still be using it. So again, just want to confirm that the utility is copying and not actually moving?
 

TomBascom

Curmudgeon
This might be a basic response but I am not at all familiar with what new system you are using and I don't have any idea, really, which of the dozens, or possibly hundreds, of brand name OpenEdge ERP systems you are migrating away from. It might be good to mention their names - just in case they "ring a bell".

Who is supplying this conversion tool?

Without knowing anything specific, other than that OpenEdge and MS SQL are somehow involved, I imagine that any such tool is just copying the data and leaving the source data behind. That's what I would do if I were coding it without any specific requirements to the contrary.
 

jacs

New Member
This might be a basic response but I am not at all familiar with what new system you are using and I don't have any idea, really, which of the dozens, or possibly hundreds, of brand name OpenEdge ERP systems you are migrating away from. It might be good to mention their names - just in case they "ring a bell".

Who is supplying this conversion tool?

Without knowing anything specific, other than that OpenEdge and MS SQL are somehow involved, I imagine that any such tool is just copying the data and leaving the source data behind. That's what I would do if I were coding it without any specific requirements to the contrary.
We are using Epicor Vista with OpenEdge 10 Progress database. In order to easily manage the data transfer into the the new Epicor Kinetic versions' database which is MS SQL, I would like to create a copy of the Progress database into MS SQL to work off of that. This is the screen I am asking about in the conversion utility to know if this is an actual move or just a copy: 1651847172051.png
 

TomBascom

Curmudgeon
Thanks!

Someone else might know but I do not happen to know what that particular tool will do if you check that box. If nobody pipes up I suggest a quick call to Epicor as your best bet.

Is this a test system? You could always give it a try if it is. I see that the database name is "sports2000", that is the "demo" database so I'm thinking that you could just try it and see what happens. (The usual Epicor database name is "mfgsys" isn't it?)
 

jacs

New Member
Thanks!

Someone else might know but I do not happen to know what that particular tool will do if you check that box. If nobody pipes up I suggest a quick call to Epicor as your best bet.

Is this a test system? You could always give it a try if it is. I see that the database name is "sports2000", that is the "demo" database so I'm thinking that you could just try it and see what happens. (The usual Epicor database name is "mfgsys" isn't it?)
I was not even thinking of that, we do have a test database, thank you. The sports200 is just a screen from a video I was watching on how to migrate, so not my database. Thanks again, I will try our test database.
 

Stefan

Well-Known Member
The tool is Progress Data Administration. I'm fairly sure that move is just a poorly chosen name, since it just creates insert statements for all your data and does not remove your original data.


Allows you to specify whether to populate the foreign data source with your OpenEdge data after the schema has been migrated. Specify YES to dump and load data or NO to not populate the database. For example, you might specify NO if your database is large, and you want to dump and load data at a more convenient time.
 
Top