Create Branch Database is used to prepare a database for a new branch server.

This process does the following:

1. Creates and configures a "Server Connection" between "Head Office" and the new branch server
2. Backup the Head Office database
3. Restores a copy of the Head Office database as: <Branch Database Name>_<YYYYMMDDHHMISS>
4. Clears all transactions in the branch database
5. Creates a "Server Connection" between "Branch" and "Head Office".
6. Backup the Branch database
7. Deletes the copy of the Branch database that was restored in step 3 above from the Head Office SQL Server.

1. Enable process "SYS001"
2. Create the Server for "Head Office"

1. Create the Server for the new branch.
2. Edit the branch server and tick "Create Branch Database". Refer to Figure 1.
3. At this stage, the background process "SYS001" will prepare the branch database. Refer to the log under "Notes and Attachments -> Notes". Refer to Figure 2.
   1. Location of database backup
   2. Instructions on how to restore and configure the new branch database.
4. Restore the backup from Figure 2.1 on the new branch SQL Server. Ensure the database name is the same as what was used to configured replication at Head Office.
5. Using SQL Server Management Studio (SSMS), execute the following scripts on the branch database. These files are located in folder <Installed Directory>\Link Technologies\DB Scripts
   1. 99998-LINKSOFT Data Updates.sql
   2. 99999-LINKSOFT Post Upgrade Scripts.sql
6. Login into the Branch Database Web Portal and configure the replication in "Server Connection"

Figure 1: Create Branch Database

Figure 2: Create Branch Database Log