Any recommendations of methods to do incremental upload, update and delete?
Besides the main database, I can setup a staging database in order to accomplish this.
Also if there are some online article recommended for the best way of doing this. I'm thinking using Merge function. But it has to be in excute t-sql task.