Merge all New Transactions with Deleted Ones in another Backup

Dec 21, 2006 0 Replies

I backed up the Store Operations (MSDE) database before deleting all transactions in RMS Admin. Please don't ask me why I did the delete! Next day I continued selling so new transactions for new sales were entered into the same transactions-empty MSDE SO database. Now I want to merge the transactions together (the old ones deleted a day earlier and new sales since then) to produce one total database. Now I want to generate historical detailed sales reports from the two physically separate transactions files stored in two separate backups as if I did not perform the 'delete transactions'. Thanks for the help!


Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required