June 28, 2004 at 6:52 am
Anyone have any information on doing this without a third party program? Perhaps using SQL-DMO? Any source code out there? Thanks
smv929
June 28, 2004 at 5:23 pm
June 29, 2004 at 6:55 am
I am able to use DTS, but just to pull data blindly into empty tables. Using DTS doesn't allow real time reporting, but I am planning on using it for reports that don't require real time. If you have any DTS suggestions, please let me know.
For realtime reporting I wanted to basically use a SQL Server linked server pointing to progress. It's slow and functionality is limited. You have to use a statement like
Select * from OPENQUERY(linkedserver,'select * from table where ''fieldname''=''123''')
If you put the where clause on the outter part, the openquery will return the entire table which is too slow. This prevents me from creating views. If anyone has suggestions for realtime reporting using linked servers to Progress, please let me know.
smv929
June 29, 2004 at 7:21 am
Can be done with SQL-DMo.
The SQLReplication Object, has an event called Status, wich will return a message (How many transactions are been replicated) and a percentage value (wich can be put in a progress bar).
Also there are two other properties, wich informs you haw many pending transactions are left at the subscriber.
Check in BOL for properties, methods and events.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply