Is there any possible way to restore database with only merge or insert options instead of deleting or replacing data (SQL Server 2014)

Question

I used the following command for restoring a database:

RESTORE DATABASE TorqueNet 
FROM DISK = 'C:\Backup.bak';
GO

This command deletes the existing data and performs a complete data replacement.

Instead of that, I want to append new data and replace existing records if there are any changes but keep existing data.

What is the source of the backup? Is the backup from this server or another server? — SS_DBA
– SS_DBA, Commented Apr 5, 2019 at 12:45

Steve Drake · Accepted Answer · 2019-04-05 13:04:30Z

1

If I understand you, no you cannot. A database restore will overwrite the destination.

It sounds like you are wanting to merge one database into another, which can be done with 3rd party tools.

You would need to

If this is a task that you need to repeat, then you could probably create an SSIS package to help you automate the process.

If you have a search for SQL Merge tools, or look at this question

A restore is replacing the database, its not running any kinda of insert or update transact sql it really is just overwriting the database.

answered Apr 5, 2019 at 12:56

Steve Drake

2,0582 gold badges22 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1