Copying all records from an old PROGRESS db which have been modified in the last day into a SQL 2012 db

Question

Copying all records from an old PROGRESS db which have been modified in the last day into a SQL 2012 db

jeichelber

Old Hand

Points: 326
More actions
April 18, 2014 at 10:48 am

#292635

Hello all,
This feels like it is probably a noob question, but I don't know exactly where to post. (If this question is more appropriate in another forum, please let me know)
I would like the ability to copy any rows that have been updated or added in the past day from an old (very old but still in production) PROGRESS database into a SQL 2012 database.
I would like to do this because it is extremely complicated to try and build SSRS reports using OPENQUERY on the old databases.
Ideally, I would like to be able to schedule a query every morning at 12:01 that updates the new databases with any changes made in the past day.
Is this even possible?
My thinking is that there is probably some sort of system field like dateModified or dateCreated that I could use for this type of query, but I just don't know.
Any guidance would be very helpful.
Sincerely,
James

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

jeichelber (4/18/2014)
Hello all,
This feels like it is probably a noob question, but I don't know exactly where to post. (If this question is more appropriate in another forum, please let me know)
I would like the ability to copy any rows that have been updated or added in the past day from an old (very old but still in production) PROGRESS database into a SQL 2012 database.
I would like to do this because it is extremely complicated to try and build SSRS reports using OPENQUERY on the old databases.
Ideally, I would like to be able to schedule a query every morning at 12:01 that updates the new databases with any changes made in the past day.
Is this even possible?
My thinking is that there is probably some sort of system field like dateModified or dateCreated that I could use for this type of query, but I just don't know.
Any guidance would be very helpful.
Sincerely,
James

this is possible.....but is dependent upon your knowledge of the Progress db and what tables/columns you require and most importantly ....what is the indicator in Progress that allows you to filter on datemodified.

we currently run an ETL process from Progress to SQL to deliver similar to your question ..but to assist would need more details on connection/process/recurrence etc

will be happy to discuss more

JLS

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

jeichelber Old Hand Points: 326 More actions · Answer 2

Thank you for the information.

It looks like I will have to hobble along with overly complicated PROGRESS queries until the company decides to upgrade our systems.

They promise that it will be before Jan. 1, 2015! (We will see)

I really appreciate that you took the time to think about my issue.

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

jeichelber (4/18/2014)
Thank you for the information.
It looks like I will have to hobble along with overly complicated PROGRESS queries until the company decides to upgrade our systems.
They promise that it will be before Jan. 1, 2015! (We will see)
I really appreciate that you took the time to think about my issue.

don't bail out yet !!

have you a dateModified or dateCreated column in you progress tables?

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

jeichelber Old Hand Points: 326 More actions · Answer 4

I spoke with the program developers and they said that there are no columns like that.

That is why I was going to bail.

I spoke with a gentleman that is an expert at combining our specific databases with SQL and he said that there isn't a practical way of doing this because of the way they designed the program back then.

Thank you once again for your thoughts!

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

jeichelber (4/18/2014)
I spoke with the program developers and they said that there are no columns like that.
That is why I was going to bail.
I spoke with a gentleman that is an expert at combining our specific databases with SQL and he said that there isn't a practical way of doing this because of the way they designed the program back then.
Thank you once again for your thoughts!

too bad for you.....

what volume of rows/tables are you involved with?

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