|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Programatic replicationI have SELECT access to a database that is very, very slow to work with to
the point where I am looking to replicate at least one table to my own server to use the data locally. What is the best way to check for new records if the table key is not incremental? I prefer not to try a "If exists" on the entire databse every minute or due to the speed issues. Hi
If you are allowed to change the structure of the table then you may want to add a rowversion column. If not maybe you should use log shipping to recreate the whole databases? John Show quote "Dave S." wrote: > I have SELECT access to a database that is very, very slow to work with to > the point where I am looking to replicate at least one table to my own > server to use the data locally. What is the best way to check for new > records if the table key is not incremental? I prefer not to try a "If > exists" on the entire databse every minute or due to the speed issues. > > >  |
|||||||||||||||||||||||
Other interesting topics