Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For more complex data updates (such as entering documents which have many affected tables), you can dedicate a (or bring up a special) test environment for the data entry. Then, bring down the instance and extract the updated data using a database tool. You then replay that data into the OLEDBA schema.

The trick with this option is identifying all the changes you want to extract. This is a place that the impex tool could help. Take an export of the database after the data entry into a new directory. Then, compare that to the baseline export from subversion. The data files which have been changed will tell you which tables were updated. This will probably still require some manual filtering out of the "noise" tables, but will definitely show you every table which was modified.

Option 3 - Special Batch Jobs to Load Data

...