I have access to a database which I can not make any changes to but need to get updates every 5 seconds to 7 diferent tables. I can not create stored procedure or triggers since the development organization has not time to test any change to te database. They have offered me read-only access to the 7 tables I need and will permit me to run a process on their Windows 2000 machine, where the databae resides.
I would like to write a "robot" which will check the database and update my database, on a remote machine, anytime a new record shows up in any of the seven tables.
What's the easiest way to do this? It could be a C# Windows program so that I can provide a status widow, etc. Or it could be a database program, I suppose.
The OS is Windows 2000 and the database is the SQL version before SQL Server 2005.