September 2, 2005 at 9:23 am
I am new to advanced topics in SQL server and have a question on replication (or other services as I may be confused!)
I have a UNIX server running a Progress database that has an ODBC driver. Every night we have scheduled DTS jobs pulling data from the Progress DB into our MS SQL server. The performance is very poor (due to the ODBC driver from Progress).
I really want to get the SQL server to be near real-time with the Progress database. I have been trying to figure out if there is some way that I can "subscribe" the SQL server to the ODBC data source and scan for new records (although, like I said, the ODBC driver performance is poor).
Is there a better way (rather than DTS jobs at night) for me to pull data from the UNIX box into our SQL data warehouse?
Any feedback or a point in the right direction would be appreciated.
September 5, 2005 at 6:25 am
Maybe try pushing from Progress to SQL via SQL's ODBC (I think you can get something like it for *NIX boxes)? I have similar problems with SQL accessing DBFs - got it faster to use a native DBF library and generate the data to push into SQL rather than using ODBC.
April 25, 2006 at 6:52 pm
Hi Ian,
Can you be more specific?. I'm trying to do the same thing.
Thanks.
Roshec
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply