SQLTeam.com | Weblogs | Forums

Merge two or more different database backup(.bak) files into one new database

sql2014

#21
  1. Restore DB1.
  2. Restore DB2.
  3. Script DB2.
  4. Edit script to remove 'create database'.
  5. Run script on DB1. If you get errors, you have conflicts. Decide what to do and start again.
  6. Insert Select From on each table.