hi
I have a situation where a database is constantly updated with new records - no records are deleted, only added. I may not modify the database. The added records need to be copied to another system. how can I keep track of which records have been copied to the other system, as I may not duplicate the records on the other system and may not query that system.
What is the best possible way to do this? can I keep a duplicate of say the primary keys in a second database and write a query to compare the first with the second and extract only the non-duplicated keys? What happens when the database becomes MASSIVE?
thanks!
I have a situation where a database is constantly updated with new records - no records are deleted, only added. I may not modify the database. The added records need to be copied to another system. how can I keep track of which records have been copied to the other system, as I may not duplicate the records on the other system and may not query that system.
What is the best possible way to do this? can I keep a duplicate of say the primary keys in a second database and write a query to compare the first with the second and extract only the non-duplicated keys? What happens when the database becomes MASSIVE?
thanks!