Post reply

Data merge between databases from different environments?

  • July 15, 2015 at 9:56 pm

    #309934

    Hi all,

    hopefully can somebody help me.

    We work with a Siebel CRM application which data come from a SQL Server database in the production environment.

    Application users have deleted many records about main entities, such as Opportunities, Accounts, Activities, etc. and were creating new records til now.

    Our SQL Server database administrator made a backup of the production database containing all records before their accidental elimination. He would restore it to the database in the testing environment, so we have the data recovered at least there. So:

    - the database in the testing environment would contain the backup content from the production environment and

    - the database in the production environment would contain all data including the new ones, with exception of the eliminated data

    Question is:

    how can we proceed if we would like to merge both contents, so we can insert the eliminated data in the production environment? I mean, finding the data which were eliminated in the backup and inserting them in the database of the production environment if we are talking about more than 20000 records in total.

    Any tips will be pretty welcome.

  • July 16, 2015 at 10:57 am

    #1813077

    20000 records isn't all that much. It should be relatively straight forward to just grab the ROW_ID's of all the relavant entitities from your current production environment then find the ones that are missing based on the data you have restored in your test environment.

    How comfortable are you modifying the data directly in your production database? You can either just import the data using SSIS or whatnot or use EIM to import the missing records.

  • July 20, 2015 at 8:54 pm

    #1813765

    Thanks ZZartin for your answer, sorry for the delay of mine.

    We arranged so that our client will create the eliminated records manually.

    Certainly there are some methods in order to make massive inserts / data imports, but they have the urgency to have the issue solved as soon as possible.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply