Merging Recovered Data into the Live Data

(0) Share

Report

Posted on by Community Member

Good day All, Thank you for taking time to read my Post.

I have a minor challenge.

Client took a backup and ran year end process, took another backup the following day and restored backup from the previous day to correct a few transactions.

Problem is Transactions that were captured between the backup and restoration i.e Bank Management Receipts, Payments, Purchase Orders and Receivings were lost when backup from previous night was restored.

I managed to recover and identify the lostTransactions from the transaction logs and also from the last backup the client took.

Challenge:

Merging recovered data into the live database is a challenge as the Audit Trail numbers and Transaction IDs such as the Receipt Numbers, Voucher Numbers and CB Audit Trail numbers have now been assigned to New transactions in the Live database.

Any thoughts on how I should best approach this ....just your thoughts. I am not looking for solution. I have an idea but not sure if it will work.

Many Thanks,

*This post is locked for comments

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

RE: Merging Recovered Data into the Live Data

Hi Jonathan,recapturing the transactions is not an option but as you say that would be the safest bet.Thing is we are looking at recovering more than a thousand transactions for that day only.
Community Member on at

Like (0)

Report

RE: Merging Recovered Data into the Live Data

Thank you Mahmoud for your response. I had already identified the missing transactions using Visual Studio 2012's SQL Data Compare.

Since the GP Structure of Tables is quite complicated. I have decided to extract the missing transactions to CSV and import them back into Dynamics GP through Integration Manager.
Jonathan Fear on at

Like (0)

Report

RE: Merging Recovered Data into the Live Data

I agree with Mahmoud on this one. If you don't push the correct values in all the necessary tables you could run into more issues. If it was me I would have the customer restore back before this all happened and do the process over just to be on the safe side.
Suggested answer

Mahmoud Saadi 32,738 on at

Like (2)

Report
RE: Merging Recovered Data into the Live Data

Hello Nursh

This could absolutely be a difficult task, especially if you are looking to work on the database level to merge recovered data into the live database. Although, I may have another approach yet quite difficult as well to consider in order to merge the corrupted data addressed below:

Initially, you absolutely need a specific method on the database level to summarize all the recovered transactions within that specific day. In order to do so, there is a genius product called (SQL Data Compare) by Redgate which main purpose is to compare data between two databases, you can specify a range of tables to consider. Once performed, it will provide a huge result of the data missing, and matched between the two databases. You can filter by the missing records in order to have a list of all the transactions across modules

Now, merging these transactions into the Live environment is preferred to be manual or through simple integration tool such as "Macro", never consider database insert for such a huge number of records since it will be an absolute nightmare

I have previously considered the SQL Data Compare for a similar case in which I had to compare missing data between live and backup, it was quite difficult but doable. Remember, that this approach requires a high level of know-how in the database structure and tables of Dynamics GP.

Furthermore, you can simply live with your current back up and inform the associated departments to re-enter the transactions of that specific day.

I will keep you posted in case I had another approach to be considered,