June 28, 2004 at 7:03 am
Anyone have any examples of any code (VB, asp, TSQL?) of replicating Progress database tables to sql server? Thanks.
smv929
July 1, 2004 at 8:00 am
This was removed by the editor as SPAM
July 1, 2004 at 8:42 am
You are just needing to copy the data from Progress Database to your SQL Server? If so then as long as you have the client installed on the SQL server and can access the Progress DB remotely then you can use DTS to setup a transformation to copy from one to the other and schedule it to run as needed.
July 1, 2004 at 10:35 pm
I am using DTS now for reports that don't require real time data. However, I was wanting to implement real replication -- where data is near real time. In which case, using DTS would like be reinventing the wheel unless there is a fairly simple compariison script that could be implemented.
Any suggestions on a script to replicate replication?
smv929
July 2, 2004 at 5:30 am
Sorry unless Progress has a connecto for replication to SQL I don't see a replication method. Might need to create a filed in the table for a date time value and trigger a change on any rows updated and default for inserts. ALso a flag column for deletes as opposed to actual deletes so sql can montior or a delets table with the key values based on a trigger from the original table. Then you could create a DTS package to logically process the differences and schedual to run over and over either by going back to step 1 or just timed every mintue or so. That is the best I can think of right now.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply