November 26, 2002 at 1:08 pm
We have an external vendor who has a copy of several tables in our database. Each week, I need to send them a file of all the records that have changed during the previous week. The idea is that they will then programmatically make those changes to their copy of the database. What is the best way to do this? Any ideas?
November 26, 2002 at 1:22 pm
Can they just take a differential backup? Replication will work, but that may be overkill.
If it's a few tables, you could just create an audit table and use triggers, then export the data and create SQL to upload this to the other server.
Steve Jones
November 26, 2002 at 6:01 pm
If their database is live then a differential will not work. Any you cannot backup their database then restore it with no recovery and apply a diff as the internal numbers will not match.
However the later is probably you best bet. Or add a DateModified column to all the current tables you need data from and fix either with INSERT or UPDATE statement using GETDATE or a trigger on UPDATE and a DEFAULT for INSERTS to refresh the value on the datemodified filed itself. Then you can pick your own method of sending them the updates, bcp to text file. UpdatesDB backup they restore and move. DTS to a temp table onm their server. The list goes on.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply