How To Setup Team Sports HQ Replication
Search
3) Update Repl_Default_SelectedLocationID in Control Panel Mainengine
3b) Go to the tracks table & change the description to the track name (ex: 'Nottingham'), change the location (very last column) to the new current location #
3c) Go to EventReservationType table and change the description to the new track name (ex: 'Nottingham') and change the location to the new current location
3d) Go to the HQ server>V8>Tracks> add a new track copying the track info from the new server. Go to EventsReservationTypes and do the same thing.
**note= The information has to be exactly the same and the locations must be the same and match the new location #
4) Test cs_replication.exe -- open cmd prompt, enter cd c:/clubspeed/cs_replication > enter cs_replication.exe
** If you don't see anything pop up, then it is good
5) Push New Customers from New track to other locations
You shouldn't get any error messages. It should say it affected # of rows.
6) Catch up a Track's replication - Run at each location changing the SyncDate & track destination
**NOTE: access is granted or denied based on the url in Locations table (track.cst.com) instead of IP addresses in IIS>Services>IP
How To Setup Team Sports HQ Replication
SETUP NEO REPLICATION FOR NEW TS TRACK
The follow was used for location 16, change for the new location. All the variables you need to change are highlighted in red, don't forget the ones around line 171.
From the NEW LOCATION
From Head Office
1613LeedsDockland16132) Update the Location Tables steps 5 to the end. Make sure to change the Repl_IsCurrent to True for this location and False for all others3) Update Repl_Default_SelectedLocationID in Control Panel Mainengine
3b) Go to the tracks table & change the description to the track name (ex: 'Nottingham'), change the location (very last column) to the new current location #
3c) Go to EventReservationType table and change the description to the new track name (ex: 'Nottingham') and change the location to the new current location
3d) Go to the HQ server>V8>Tracks> add a new track copying the track info from the new server. Go to EventsReservationTypes and do the same thing.
**note= The information has to be exactly the same and the locations must be the same and match the new location #
4) Test cs_replication.exe -- open cmd prompt, enter cd c:/clubspeed/cs_replication > enter cs_replication.exe
** If you don't see anything pop up, then it is good
5) Push New Customers from New track to other locations
You shouldn't get any error messages. It should say it affected # of rows.
6) Catch up a Track's replication - Run at each location changing the SyncDate & track destination
**NOTE: access is granted or denied based on the url in Locations table (track.cst.com) instead of IP addresses in IIS>Services>IP