Merge Databases into Separate Outlets

• It is OK to be logged into the outlet that you are updating - when your running this routine, as it will force you back to the login window when the process has been completed.
• Have all users and web services 100% logged out of the outlet you are updating.
• This process will disable triggers one table at a time, as the table is update.
• If your running this in a live environment where other outlets still may be using the database, perform this function when there is no access to the database from users, or web sales (i.e. after midnight). Due to the fact that triggers are being disabled on a table while the table is being updated.
• This routine is fairly fast but does depend on the hardware it's being run on. Running this process on a fully loaded server, a normal database may take anywhere from 5 to 10+ minutes to complete. On a large database (4 GB compressed backup), it may take anywhere from 15 to 30+ minutes to complete.

Timeline of Action Events

1. Secondary Database Location
   1. Update your website to let people know web sales is offline for system upgrades.
   2. Web Sales come off line, all workstations quit using Theatre Manager & log off all Terminal Services sessions
   3. Box offices complete their EOD processing, run reports, etc.
   4. Box Office workstations quit Theatre Manager, and log off all Terminal Services sessions
   5. Backup Secondary Database
   6. Transfer Secondary Database to Primary Database Location
2. Primary Database Location
   1. Restore Secondary Database
   2. Backup Primary Database
   3. Set Secondary Database's Outlet Number
   4. Update Secondary's Database Sequence Numbers
   5. Export Secondary Database
   6. Import Secondary Database

   After Merge has completed

   1. Access to Theatre Manager’s merged database for key people to review data
   2. Once review is completed by key people
      1. allow box office to use the database
      2. bring web sales online (via Theatre Manager >> Company Preferences >> Web Options)
      3. review web sales online appearance
         • make adjustments to Theatre Manager’s code table values as required
      4. once given the go ahead for web sales
         1. update your website to let people back having access to the ‘buy tickets’ buttons.

      Reset the "Secondary-Client" Outlet Number - Set the Outlet number to be what you would like the Outlet number to be in the final merged database

      1. Download the most recent "Secondary-Client" database
      2. Restore the downloaded "Secondary-Client" database
      3. Using the Developer Tool, Log into the "Secondary-Client" database as the Master User
      4. Reset Department Number (File >> Import/Export >> Outlet Settings >> Outlet Preferences)
      5. Enter in the FROM Outlet Number
      6. Enter in the TO Outlet Number
      7. Click "Reset Dept"
   3. Make a backup of the "Secondary-Client" database
   4. Download the most recent "Primary-Client" database
   5. Restore the downloaded "Primary-Client" database

   Reset the "Secondary-Client" Sequence Numbers - Sets the Sequence numbers for every table and connecting child records to be different then what is in the "Primary-Client" database

   1. Using the Developer Tool, Log into the "Secondary-Client" database as the Master User
   2. Reset Database xxx_SEQ Values (File >> Import/Export >> Outlet Settings >> Outlet Preferences)
   3. Click "Merge DB"