How to Relocate a STRATA Master Database

Overview

The following instructions will help you relocate your STRATA Master Database to a new server, repeat these steps for all databases (i.e Rentals and Sales)

NOTE: We recommend that these steps are performed by your IT Technician with sufficient planning and testing

Please allow additional time if the following additional products are in use

  • fileSMART must be relocated by Rockend, if you require a fileSMART server relocation please refer: How to Relocate a fileSMART Server
  • STRATA Communciator, (check Programs & Features for 'Rockend Web Access'), this must be uninstalled from the old server and installed on the new server
  • Refer to STRATA Communicator Installation Guide for the relevant instructions

Steps

  1. Contact Rockend to obtain the full install package for STRATA Master
  2. On the new server, perform a new complete installation of the STRATA Master server - instructions are located in the full install package. This will create a blank database, ensure you can log into STRATA Master using the default credentials; 
    • Username: administrator
    • Password: administrator
  3. Relocate the SQL database
    1. On the existing server, open STRATA Master and perform a Backup
    2. On the new server, open STRATA Master and perform a Restore
  4. Merge the following folders from the old strata$ share to the new strata$ share:
    \ Documents - all
    \ Graphic - all
    \Template - all
    \Data - Only merge non SQL Database files (IE: merge any .pdf or .rtf files but do not merge the .ldf or .mdf files)
  5. Open STRATA Master on the new server and reconfigure the paths for the following features.  Note any additional folders that need to be relocated to the new server
    • Graphics: Configure > Agency > Options 1
    • Bank Statements: Configure > Bank Statement Filing
    • Download Configuration: Configure > Download
    • Backups: Configure > Display and Set Config Values > Backup
    • Banking File: Accounting > Process Direct Entry Payments
    • Bulk BPAY File: Accounting > Process Bulk BPAY Payments
    • Document Directory: Configure > Display and Set Config Values > Backup

NOTE: When configuring the Document Directory if the location is blank then no changes need to be made (the default will be \\CurrentServerName\strata$\documents).  Otherwise it has been altered outside of STRATA Master and needs to be manually updated in SQL Management Studio under strata\dbo.Config\sDocumentsDirectory

  1. Reconfigure the STRATA Master workstations by altering the UDL connection - default location is c:\strata\strata.udl.  Ensure other relevant servers are updated such as fileSMART
  2. Check if STRATA Communicator is installed (check Programs & Features for Rockend Web Access).  This must be uninstalled from the old server and installed on the new server. Refer to our STRATA Master Knowledgebase for the relevant instructions

We strongly recommend disabling the old SQL Server services to protect any workstations that may have been missed.


09/09/2019 11:22 am AEST

Still need help?

Request a New Article

Popular Articles

New Articles

Updated Articles