I want to know how, or if it is possible, to backup a database then should the user wish, restore that database at a later date and merge it with the one they are currently using. Both Databases will be using the same tables and have the same fields, the difference is in the data. Ideally I would like to do this through SQL and not have to get a third party application. Any ideas or suggestions, I'm kind of in a bind here.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Jun 13 '12 at 17:52
This question came from our site for professional and enthusiast programmers.
If you have Visual Studio Ultimate or Premium, you can use "Data Compare" feature in Data menu. It can compare data between two tables and have ability to directly update your database or generate update script.