MS SQL Server must be installed on your machine or another machine on your network for you to be able to create a MS SQL Server based Globodox DBs.
Globodox Supports MS SQL 2000, 2005, 2005 Express and 2008 Server.
To Convert MySQL DB to MS SQL DB
|1.||Make sure no users are logged on to Globodox.|
|2.||Login as superadmin, from Globodox desktop client.|
|3.||Select Settings > System Settings > DB List in the Navigation pane. The DB List tab will now be displayed on the Ribbon bar.|
|4.||From the DB List pane i.e. the right pane select the DB that you want configure for multi-user environment.|
|5.||Click the Convert DB option on the DB List tab. Provide your MySQL Server Login details and click OK. The Convert DB window will now be launched.|
|6.||You can change the name for the DB from the New DB Name box.|
|7.||Select MS SQL based Globodox DB option from the DB Type drop down. The MS SQL Settings window will now be launched.|
|8.||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. The new Globodox DB would be created on this machine. The drop-down list will display the names of all the machines on your network. It is recommended to type the machine's IP address.|
|9.||For MS SQL Server 2000 or higher enter the name of the SQL Server Instance in the Instance name box on which the new Globodox DB should be created. When only one instance of SQL Server is running on a machine, the instance name is normally the same as the machine name. Leave the instance name blank unless you wish to connect to a named MS SQL server.|
For MS SQL 2005 Express edition enter SQLEXPRESS in the Instance name box.
|10.||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. Other available connection types are...|
|•||Multi Protocol/Windows RPC|
For MS SQL 2005 Express edition select TCP/IP from the Connection Type drop-down.
|11.||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.|
|12.||Choose the Windows Authentication option if the SQL Server you have chosen has been configured to use Windows authentication. Your Windows login information will be used to logon to the SQL Server.|
|13.||Choose the MS SQL Server Authentication option if the SQL Server you have chosen has been configured to use SQL Server Authentication. You will also need to specify the user name and password which Globodox should use while connecting.|
|14.||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. If this option is left unchecked then the user will be prompted for the user name and password before opening the Globodox DB.|
|15.||Click the Test button to test the connection.|
|16.||Click the OK button to save the settings and close the MS SQL Settings window.|
|17.||Click the Convert button to convert the MS Access DB to an MS SQL Server DB.|
|•||For MS Access DB: By default all Globodox Databases and its File Stores are stored in the C:\Globodox Databases folder. File Store is a normal Windows folder which is located inside a folder with the same name as the name of its related DB.|
|•||For MS SQL SERVER: By default all Globodox Databases are are stored in the SQL Server Management Studio. File Store is a normal Windows folder which is located inside a folder with the same name as the name of its related DB.|
|•||For MySQL: By default all Globodox Databases are stored in the My SQL Administrator. File Store is a normal Windows folder which is located inside a folder with the same name as the name of its related DB.|
Convert a MS Access DB to MySQL DB
Convert MySQL DB to MS Access DB
Configure Globodox DB for multi-machine environment