I have created a SQL Server Express database that is being placed on external HD. I need to add / update the data along with the database on my system, as well as other systems and then only backup or transfer data that has been added or edited in the external hard drive. What is the best way to accomplish this?
You probably will use replication for it but as you express it using SQL Server There is no option.
You will need a mechanism to determine what has changed between backups, so each table will need a timestamp or a last updated date time column, each time a record is entered or updated is done.
Once you know which records are included or updated, this column may be easy to update, since this was only the last time the action was taken It's a matter of searching.
An option is to add a bit column which is updated but it looks less flexible.
No comments:
Post a Comment