ProgressDB data dump to SQL server DB

Question

ProgressDB data dump to SQL server DB

jansub07

Say Hey Kid

Points: 709
More actions
September 15, 2016 at 3:57 am

#330190

Hi,
How to move the ProgressDB data dump to SQL server DB. It is one time activity. More than 1000 tables are there like this.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 1

have you seen this article

https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmsql/migrating-an-openedge-database-to-ms-sql-server.html#

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

jansub07 Say Hey Kid Points: 709 More actions · Answer 2

Yes i visited that document. But the OpenEdge tool is not accepted by client environment. Another thing they only provide the data dump. Connecting ProgressDB through providers are not allowed. Apart from OpenEdge any other solutions possible.

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

jansub07 (9/16/2016)
Yes i visited that document. But the OpenEdge tool is not accepted by client environment. Another thing they only provide the data dump. Connecting ProgressDB through providers are not allowed. Apart from OpenEdge any other solutions possible.

"Connecting ProgressDB through providers are not allowed".....can you explain what you mean please

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

jansub07 Say Hey Kid Points: 709 More actions · Answer 4

Not permitted to connect the ProgressDB. Only data dump is provided

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 5

is this just the data or do you have the file definitions as well?

probably better if you ask your question on a specific Progress forum like Progresstalk

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day