<< Click to Display Table of Contents >> Navigation: Technical Informations > Database - Dual Database Partial Cross Synchronisation > How to use the SQL script > Customise the SQL script |
In this script there is a part where the variables must be personalized to be compatible with your infrastructure :
List of Variables (you must change the part in blue) :
>> SQL Version
-- Adjust driver version for you SQL Server version (the default settings should be ok in most case)
SET @sql_client_version = N'SQLNCLI'
>> SYSADM credentials for the secondary (remote) database
-- the SYSADM password for the remote database
SET @ra_sysadm_password = N'Your SYSADM password here'
>> The peer server hosting the secondary (remote) database
-- the peer server hosting the other database (eg. on primary set here the dns name of secondary server and vice and versa)
SET @ra_ddb_sync_peer_server = 'NUCTRDASQL02'
>> Set here the name of the local Database (ABC8 or other)
-- set here the ABC8 name on the local server if different from default
SET @ra_ddb_sync_local_db = 'enterherethedatabasenameofthelocalserver'
>> Set here the name of the peer (remote) database
-- set here the ABC8 name on the peer server if different from default
SET @ra_ddb_sync_peer_db = 'enterherethedatabasenameofthepeerserver'
>> Scheduled time for synchronisation
-- scheduled time for synchronisation job HHmmss et 11:33 PM = 233300 Offset by at least 30 mins each server
SET @ra_ddb_sync_time = 033000
In this exemple the sync time is set at 03.30 AM