Moving MS SQL-based Globodox Databases to New Location

Print this Topic  Previous Topic Home Topic Next Topic
You are here: Globodox DB > Moving Globodox Databases to New Location >Moving MS SQL-based Globodox Databases to New Location
Expand All   Collapse All

Assumptions:

1.We are assuming all the folders linked to all your Globodox DBs are located inside a single root folder (for e.g. C:\Globodox Databases) on the old machine. i.e. if we move this single folder to the new machine, then we would have moved all the file stores for all the DBs.
2.You have backed up all your Databases and their file Stores
 

The following are the instructions for moving the folders linked to all Globodox DBs to the new machine...

I. Moving the DBs and the File Store to the new machine

1.Make sure Globodox is not running on any of the machines on the network.
2.Using Windows Explorer copy the root folder (i.e the Globodox Databases' folder) to the new machine. We are copying and not moving so that we can revert back to the old setup if required.
3.Make sure users have permissions on this new root folder (see the permissions on the root folder on the old machine for reference).
4.Share the folder on the new machine. Make sure users have permissions on this new share (see the permissions on the share on the old machine for reference).
5.Rename the share for the root folder on the old machine. The aim is to make sure Globodox can no more access the files on the old machine.
6.Now, move the backed-up copy of the MS SQL based Globodox DBs to the new machine.
7.Install MS SQL Server on the new machine.
8.Restore the backed up MS SQL based Globodox DBs on the new machine.
9. Install Globodox on the new machine.
10.Now, copy the multi-user.gdx file from the ITAZ\Globodox folder, created under the folder designated as the Common Application Data folder in the Windows installation, of the old machine.
 
For Windows Vista/Windows 2008/Windows 7, this will be the C:\ProgramData\ITAZ\Globodox folder.
For Windows 2000/XP/2003 this will be C:\Documents and Settings\All Users\Application Data\ITAZ\Globodox
 
Note:
If Globodox is launched after the installation you may get this message "Required configuration file 'multi-user.gdx' does not exist or access denied". Just close the message box and follow the above step.
 
11.Now, paste this file in the ITAZ\Globodox folder located on the new machine.

 

II. Configuring Globodox to launch the Main DB from the new location

1.Open the Command Line Window (Start > All programs > Accessories > Command Prompt).
2.In the Command Line window type the following at the cursor...

"C:\Program Files\Globodox Desktop\Globodox.exe" /reconfiguremaindb
(Assuming that Globodox is installed in the default location.)

3.Now, hit the Enter key.
4.Globodox will now launch. The DB Details window will be launched.
Specify the details to connect to the new MS SQL Server
a)Enter or select the name of the machine on which MS SQL Server is running from the Choose or type in a machine name box. It is recommended to type the machine's IP address.
b)For MS SQL Server 2000 or higher enter the name of the SQL Server Instance in the Instance name box.
Note: For MS SQL 2005 Express edition enter SQLEXPRESS in the Instance name box.
c)Select the type of connection Globodox should use to connect to SQL Server from the Connection Type drop-down. The Default connection type is selected by default.
Note: For MS SQL 2005 Express edition select TCP/IP from the Connection Type drop-down.
d)In case you have chosen the TCP/IP connection type then specify the port number in the Port box. The default port used by MS SQL Server (port 1433) will be displayed in this box. If the MS SQL Server you have chosen uses a different port number then you must enter that port number in this box.
e)Choose the Windows Authentication option if the SQL Server you have chosen has been configured to use Windows authentication.
f)Choose the MS SQL Server Authentication option if the SQL Server you have chosen has been configured to use SQL Server Authentication.
g)Check the Remember Password option you want Globodox to remember the user name and password and automatically apply it when the Globodox DB is opened.
h)Click the Test button to test the connection.
i)Click the OK button to save the settings and close the MS SQL Settings window.
5.After this is configured, you will get a message confirming that Command Line action has been completed. Globodox will now close.
6.Start Globodox. The Main DB will now be opened (Assuming that is set as the default DB).
 
Note:
If the Main DB is not set as the default DB then follow the below to launch Main DB...
Launch the Command Line Window. In the Command Line window type the following at the cursor.
 
"C:\Program Files\Globodox Desktop\Globodox.exe"/ignoredefaultdb
(Assuming that Globodox is installed in the default location.)
 
Now, hit the Enter key. The Main DB will now be launched.
7.As you browse through the DB, you may get File not found message as the File Stores are still pointing to the old location. You will now have to point the Main DB to use the new File Store location. To do this follow the Steps below.
8.Click Settings > DB Settings in the Navigation pane.
9.Select the File Store node. The File Store will be displayed in the right pane, i.e. the File Stores list.
10.Double click the current Default File Store from the File Stores list. The File Store window will now be launched.
11.Click the Browse... button to specify the new location of the file store. This is usually the C:\Globodox Databases\MainDB\Default File Store folder
12.Click the OK button to select the new location.
13.Click the Save and close button to save the settings.
14.Now, go to to Workspace. The documents will now be displayed.

 

III. 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. The DB Details window will now be launched.
3.Specify the details to connect to the the DB located on the new MS SQL Server.
4.Click the Save and close button to save the changes.
5.Now, open the DB and change its File Store location. Follow the above steps for all the remaining DBs.

 

IV. Pointing Globodox clients to the server installation

1.Make sure you have configured the DB's for multiple-users.
2.Copy the multi-user.gdx file from the ITAZ\Globodox folder located on the new machine.
3.Now paste the multi-user.gdx file in the ITAZ\Globodox folder on all the machines on which Globodox is installed.
4.Start Globodox Desktop client on another client machine and open a Globodox DB. Check if it opened successfully.
 

If everything works fine then you can uninstall Globodox and delete the Globodox Databases folder from the old machine (assuming you have already taken a backup of the Globodox Databases folder)

That's It!

 


Page URL: http://www.itaz.com/globodox/help/index.htm?moving_ms_sql_based_globodox_databases_to_new_location.htm