Customise the SQL script

<< 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 :

 

Script01FR

 

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