Convert MS SQL DB to My SQL DB

Print this Topic  Previous Topic Home Topic Next Topic
You are here: Globodox DB > Convert DB >Convert MS SQL DB to My SQL DB

MySQL Server (Version 5) must be installed on your machine or another machine on your network for you to be able to create a MySQL Server based Globodox DBs.
 

To Convert MS SQL DB to MySQL 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. 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 MySQL option from the New DB Type drop down. The MySQL Settings window will now be launched.
8.Enter or select the name of the machine on which MySQL 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.Enter the port number in the Port box to connect to the MySQL Server. The default port used by MySQL (port 3306) will be displayed in this box. If the MySQL instance you have chosen uses a different port number then you must enter that port number in this box.
10.In the Username box enter the user name that Globodox should use when connecting to the MySQL Server.
11.In the Password box enter the password that Globodox should use when connecting to the MySQL Server.
12.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.
13.Click the Test button to test the connection.
14.Click the OK button to save the settings and close the MySQL Settings window.
15.The default location of the DB's config file will be displayed in the Config file location box. You can change the location by clicking the browse button besides the Config file location box.
16.Click the Convert button to convert the MS SQL to a MySQL Server DB.

 

Notes:

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.

 


Related Topics

Configure Globodox DB for multi-machine environment

Convert a MS Access DB to MS SQL DB
Convert MS SQL DB to MS Access DB

 

 


Page URL: https://www.globodox.com/support/help/index.htm?convert_mssql_db_to_mysql_db.htm