I have backup files. I want to add that data to the existing database not over write it. Scenario: The software is installed on different systems. The data is entered from different PC's. but the data is of same type. After taking the backup(.bak)file on run-time. Now i want to combine that all data in a single database not overwrite it. I have tried How to restore to a different database in sql server? I am out of that option and after so much googling i cant get answer.Just found to overwrite the database but i dont want to loose any of the data. Thankz
Asked
Active
Viewed 250 times
0
-
1What about adding the `.bak` to a new database, extracting data as CSV and load that to the target database? – Axel Amthor May 17 '15 at 06:20
-
I am new to this part of database of restoring and backup so can you please elaborate – Obaidullah Rafiq May 17 '15 at 06:25
-
What format are the backup files in? – Pekka May 17 '15 at 06:39
-
Is it MySql or Sql server? – Zohar Peled May 17 '15 at 10:28
-
The backup files are in .bak. @Pekka and it is in local server in visual studio.I think it would be Sql Server – Obaidullah Rafiq May 17 '15 at 14:43
-
"I am out of that option" – what do you mean? You can't restore a .bak file? If so, you are out of options completely, because there is no other way to use a backup file. Maybe you just need to export your data differently, not through a backup. Only you can tell. – Andriy M May 17 '15 at 21:15
-
And how is that possible – Obaidullah Rafiq May 21 '15 at 11:02