Migrate Globodox v10 MSSQL DB

Migrate Globodox v10 MSSQL DB

Step 1:

Backup DB on old machine

Follow instructions from the link below to take a backup of the MSSQL DB...

https://www.globodox.com/support/help/index.htm?backup_a_ms_sql_db_main.htm

Note:
Make sure you take a backup of all the DBs.
Make sure you backup the multi-user.gdx file. (This file is usually located in the 'C:\ProgramData\ITAZ\Globodox' folder)          
Move the contents to the new machine.

Step 2:

Backup File Store

Note: If your File store is on a Shared drive or on a NAS, and you do not want to move the File store then you can skip this step.

All documents added to GLOBODOX are added to a Windows folder known as the GLOBODOX File Store.  The File Store is the usually the 'C:\Globodox databases\MainDB\Default File Store' folder. 

To know the location of the File Store for your GLOBODOX installation....
  • Start GLOBODOX.
  • Click on Settings. 
  • Click on the 'File Stores' node in the left pane. A list of File stores will be displayed on the right.
  • The 'Folder Path' column will display the location of the File Store.
We would recommend you to manually zip and make a copy of the 'C:\Globodox databases'  folder. Please copy the zip file from the old machine to the same folder location on the new machine. Makes sure you share this folder

Incase you have multiple DBs and have filestores stored in different locations, you will need to take a backup of these as well. The above step must be done for each DB to know the Filestore location.

Step 3:

On the new machine...

Install MSSQL Server.
Make sure you install SQL Server Management Studio as well.

Step 4:

Restore DB on the new machine.

Follow instructions from the link below to restore the backup of the MSSQL DB...



Step 5:

Install Globodox

Install Globodox (the same version as installed on the old machine)
Start Globodox once.
Close Globodox.

Replace the backed up multi-user.gdx file in the 'C:\ProgramData\ITAZ\Globodox' folder.

Step 6:

Pointing Globodox to the new MSSQL installation.

  1. Open the Command Line Window.
  2. In the Command Line window type the following at the cursor.
     
    "C:\Program Files\Globodox Desktop\Globodox.exe" /reconfiguremaindb

  3. Now, hit the Enter key.
  4. Globodox will now launch. The MSSQL DB Details window will be launched.
  5. Enter the MSSQL details for the new machine.
  6. After this is configured, you will get a message confirming that Command Line action has been completed. Globodox will now close.
  7. Start Globodox. The Main DB will now be opened
      If you have more DBs (other than the Main DB) then follow the steps below...
  1. Select Settings > System Settings > DB List in the Navigation pane.
  2. Double click a DB from the list to specify its new location. Click the [...] button. The DB Details window will now be launched.
  3. Specify the details to connect to the the DB located on the new MSSQL Server.
  4. Click the Save and close button to save the changes.
Step 6:


Pointing GLOBODOX Filestore to the new location.

  1. Open each DB.
  2. Select Settings > DB Settings >Filestores in the Navigation pane.
  3. Double click the Filestore in the list view pane.
  4. Change the path to the new machine.
  5. Click the Save and close button to save the changes.
Step 7:


Apply Registration Key.

  1. Click on the Globodox button (The round button on the top left)
  2. Click About.
  3. Click the Register button.
  4. Browse to the v10 Registeration key file. (.gxlc2 extension)
  5. Restart Globodox.

Step 8:

Make DB multi-user

  1. Click On Setting>>DB List.
  2. Make sure the Filestore folders are shared with the respective Windows users.
  3. Select each DB and click on the 'Multi-user' button on the Ribbon bar.

Step 9:

Point Client machines to the new server machine.

  1. On each Client machine, launch the Globodox Login Manager.
  2. Specify the Server URL of the new machine.
  3. Click Test Connection.
  4. Click OK.
Step 10:

Confirmation

Turn off the old machine to confirm everything is fine.
If you cannot turn off the old machine , shut down the MSSQL Service and the Globodox Server Service on the old machine.



    • Related Articles

    • Migrate v10 Globodox MySQL DB

      Step 1: Backup DB on old machine Follow instructions from the link below to take a backup of the MySQL DB... https://www.globodox.com/support/help/index.htm?backup_a_mysql_based_db.htm Note: Make sure you take a backup of all the DBs. Make sure you ...

    • Migrate GLOBODOX v10 MS Access DB

      Step 1: Backup DB on old machine Follow instructions from the link below to take a backup of the MS Access DB... https://www.globodox.com/support/help/index.htm?backup_a_ms_access_based_db.htm Note: Make sure you take a backup of all the DBs. Move ...

    • Install MS SQL Server 2014 Express Edition using GLOBODOX DB Engine utility

      Please download the GLOBODOX DB Engine utility from the link below... For Windows 64 bit: http://downloads.itaz.com/dbengine/latest/gdx-db-engine-package-sqle-x64.exe For Windows 32 bit: ...

    • Find if your GLOBODOX DB is MS Access based, MySQL Server based or MS SQL Server based

      Start GLOBODOX and go to Settings Click on DB List under System Settings Under the column name Type, you will find the type of DB (please refer to the screenshot below) That's it!

    • Upgrading to GLOBODOX v10

      This instructions are only for upgrading your existing installation of GLOBODOX. Please read this article and make sure you have all the files that are necessary for the upgrade.  Before you proceed make sure... Check your maintenance subscription ...