April 18, 2014 at 10:48 am
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
April 18, 2014 at 11:01 am
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
April 18, 2014 at 2:43 pm
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.
April 18, 2014 at 2:46 pm
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
April 18, 2014 at 3:33 pm
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!
April 18, 2014 at 3:36 pm
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply