Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I think the MERGE statement is your best option. To use this, you will need to be able to query both databases in one query (i.e. they are on the same SQL server instance or you can setup linked servers.

but i am stuck with adding the database to the same sql instance, its not working, i created a new database tried to load the backup to it and no luck, how would you do it normally?
–
user1570048Dec 28 '12 at 11:13

@user1570048. You don't have to create a DB then restore over it. You can restore to a new DB. What error do you get when restoring?
–
flemDec 28 '12 at 11:18