A new ODM Database Synchroniser highlights differences between two databases and allows data to be selectively imported.

Access the ODM DB Synchroniser under the Import menu on the main ODM Toolbar (version 3.6 only).

The Database Synchroniser lets you compare two ODM3 Databases, highlighting the differences between the two. This might come in handy when you receive a database from a colleague/client working remotely and you want to compare their database with your own. The Database Synchroniser lets you quickly spot differences.

The Database Synchroniser also lets you import selected data from one database to the other. This will come in useful where you're looking to synchronise two ODM databases or want to recover some data from a backup. You can import selected data by placing a tick in the appropriate box or by selecting one of the four options at the bottom - e.g. to import ALL data that has been updated more recently in the comparative database.

What does the Interface look like?

How do I use the ODM Database Synchroniser?

• First, select the database you want to compare with the active database.
• Complete the well/data matching processes:

  • Match wells between the two databases

  • Match discrete data types (e.g. intervals, picks) between the two databases.
  • Match log data between the two databases.
  • Match text and graphic dictionaries between the two databases.
• ODM will highlight differences between the two databases under the appropriate tabs:
  • Wells – summarises any differences between 'all data' (discrete data and logs) and 'wellpath data'.
  • Wells vs Data (discrete) – review differences between discrete data types (e.g. Lithostratigraphy or Core Data) in the two databases.
  • Wells vs Data (logs) – compare differences between logs in the two databases.
  • Dictionary vs Data (discrete). Text and Graphic Dictionaries must be assigned to particular data types in ODM (this is done from the Edit option in the appropriate dictionaries). The Database Synchroniser shows you which data type(s) a dictionary is being used for, highlighting differences between the two databases.
• Finally, providing you have appropriate administrative rights, you can then select which data you want to import to the active database and perform the import.

What do the colours/import options show?

This example below shows a comparison of wireline logs in each of the wells. Different colours are used to highlight differences, as outlined below. In this case, the blue columns show the log dictionary name (e.g. Gamma Curve) and the white columns to the right show the associated logs (e.g. GR and GR_edited).

Import options in more detail...

More detailed documentation can be found in the Helpfile in ODM version 3.6, under the 'Import Data to ODM' section. Click here to launch an online version of the ODM Helpfile.