sql server new users: SQL2K Table linked with a Progress table -- sql server new users

SQL2K Table linked with a Progress table

Tyler D.
12/19/2005 9:15:15 AM

sql server new users:

Our MRP is running on Progress. We connect to it using the Merant driver. We
run scheduled DTS overnight, but I need a particular sql table to be synced
with the Progress table. I will only read the SQL table. I'm not sure where
I should start. Any pointers would be appreciated.

Thanks

TD

Re: SQL2K Table linked with a Progress table

Anthony Thomas
12/24/2005 10:43:18 AM

Why not consider using a Linked-Server to Progress? Then, you create a VIEW
in the SQL Server database with the name of the SQL table instead, then
users will think it is a SQL Server table, but it is nothing more than a
pass-through to the Progress installation.

Sincerely,

Anthony Thomas

--

[quoted text, click to view]