<< Click to Display Table of Contents >> Navigation:  Technical Informations > Database - Dual Database Partial Cross Synchronisation > Scope of the method > Basic principle of the synchronisation

This method is intended to provide an ongoing, or on demand, partial synchronisation between selected tables of a dual database server NETIA system.

It's main purpose is to synchronise the T_ITEM table (items in the browser) by adding missing entries on both servers.

It is possible to extend to the T_RTF table (carts in cartstacks) and T_EDIT (edit sessions content).

The same approach can be applied (add in target what is in source and not in target) to these tables.  However, should there be conflicts, junk entries may be created as there is no easy way to know which DB holds the correct content.  To avoid this we can use a more selective statement (further limiting the scope of the synchronisation to relevant entries) etc.

In short the process as a whole, will copy cartstacks and edit sessions missing in one or other DB with their content, but will not synchronise cartstack modifications if edit sessions exist already for that particular cartstack.

Throughout this document the primary server will be using nuctrdasql01 and the secondary one will be nuctrdasql02. Each one may be referred to as either their function or hostname.