How to import a MSSQL database to a Godaddy host

These days, when a user asked me about the import of the ms SQL database, I found that the MSSQL database of Godaddy cannot be released through remote control or be directly restored by backing up the Bak, you must convert it to CSV to import the database. It is very troublesome, and the chances of successful operations are not high for various reasons. Finally, you can purchase the ms SQL database from another service provider and store the web page in the Godaddy space for remote connection. The answer is no. Godaddy does not allow the website on its host to connect to an external ms SQL database.

The biggest headache for Godaddy Windows series hosts is the MSSQL database problem. So here we will focus on how to import Microsoft sqlserver databases to Godaddy hosts.

Here we provide two methods for you to share. Please select the appropriate method for operation. If you have any questions, you are welcome to discuss and study them together.

Method 1:

Import the CSV file to the MSSQL Server database of Godaddy.

You can import the database from the CSV file to the SQL Shared Server database of Godaddy. If you want to import data stored elsewhere, copy the data to the CSV file. (Note: before importing a database, you must first set an SQL Server database and then store the data in the necessary tables and topics)

The disadvantage is that the database may fail if it is too large.

Method 2:

Use DPW to publish the ms SQL database to your ms SQL Server server on Godaddy. Note: DPW is the abbreviation of database Publishing Wizard. It refers to the database Publishing Wizard. It is a software developed by Microsoft and can be released for ms SQL database.

ReferenceArticleI have been reproduced on this site, you can refer to the English document to operate: http://bbs.taohost.net/thread-159-1-1.html Chinese version may be launched in the future. You can also actively issue tutorials for your sharing.

To successfully publish a database to a Godaddy host, prepare the following tools:

1. Microsoft. NET Framework Version 2.0
2. Microsoft Core XML services (MSXML) 6.0
3. Microsoft SQL Server native Client
4. Microsoft SQL Server 2005 management objects collection
5. Microsoft SQL Server database Publishing Wizard 1.1

Don't hesitate. None of these software will work if it is missing. install it in full. Pay attention to the order, it is best to install according to the above 1, 2, 3, 4, 5 order.

The procedure is as follows:

1. After the database Publishing Wizard (DPW) is installed, open the DPW client. If the welcome page appears, check the "do not show next time" box and click Next,
2. On the select Source Server Page, enter the connection information of your local SQL Server.
3. Complete the connection information. Click Next to select a database. The local database file is displayed.

Note: If you do not see the database you want to release, you will return to the select Source Server Page and reselect it. Then, do not change the connection information and return to this page. If this step does not work, it is probably your system. If you do not have control of the system, contact the server owner for help.
4. Select the database to be released. If you want to import all objects in the database, check the options above and skip the following two steps. If your database contains prohibited objects, such as full text catalogs and assemblies, or you do not want to publish all objects, do not check script all objects in the selected database. Click next:

5. If you have not released all the data objects, the choose Object Types Select Object Type dialog box appears and select the object to be released.
6. Click Next to enter the object selection type dialog box. If you want to discard and select all objects, click Select All and select all again.
7. Complete the object selection and go to the next step. Repeat the previous operation until you enter the select an output location to select an output location dialog box.
8. After the select output location dialog box is displayed, select the publish to shared hosting provider option and select the appropriate provider and target database from the drop-down list.

If you have never configured or added the Godaddy host connection option, you need to configure the database connection option yourself. If you configure it by yourself, you need to click the more... button to display a hosting providers (host provider) dialog box.
9. Important: click New here to create a new database connection. The provider configuration dialog box is displayed.
Here are some considerations:

Name: enter the name of the service provider. This name is mainly used by you to identify the provider of the database. You can customize different hosts of the same host provider.

Web service address: This is not the address of your database server, but the Web service address of your database. It supports the online import function. There is a difference between them, which directly affects whether your data can be imported. Enter the correct URL to find your database information online. Otherwise, the URL cannot be linked. In addition, this link must be in HTTPS format to ensure secure data transmission. The following describes how to query this URL: how to find the MSSQL database server address and publishing address

User name: Your FTP account name
Password: FTP account password

NOTE: If your computer is public, do not check "Save Password". The password will exist on your computer.

10. After entering all the information, you need to add a database in the blank space below. Click the new button on the right to display the database dialog box. Enter the appropriate values at the specified position, which can be found in the databases block of the control panel of the host. Tutorial: how to locate the MSSQL database server address on the Godaddy host

The field translation is as follows:

Server Name: server name. Here is the real server path. It must be separated from the preceding partition.
Database Name: database name. enter the name of the database to be imported.
User name: database username, which you entered when creating the database.
Password: Password corresponding to the user name

NOTE: If it is a public computer, do not click Save Password. Pay attention to database security.

11. after entering the information, click OK. If no database is added, the same steps are repeated. If multiple databases are provided by a single host provider, you can directly add them in this window without having to create separate databases.

After the database is added, click OK again. Return to the hosting providers list page. You can click test to test whether your database connection is valid. Click OK to return to the select an output location page. If you do not select an appropriate database provider or database, you can do it again this time.

Click Next To Go To The select publishing Options page. before entering the new page, the system first checks the database information you entered. If the connection fails, an error message is displayed, and you will return a new modification. If you can connect, you can enter the next page.
This page is generally used by default, and the options in it are not described in detail. Click Next to go to the next step.

12. On the review summary page, all related information, links, databases, and user names are displayed.
Click Finish to complete the release.

13. On the database publishing SS interface, the publishing process and steps are displayed and tracked.
The release speed is based on a variety of factors, including the host speed and local upload speed. Generally, the release can be completed within 30 minutes.

You can click STOP to stop publishing at any time. If a problem occurs during the publishing process, a red error message is displayed in the message column. If an error or failure occurs during the release process, you can click back to the previous page for modification and debugging.

Click Close to close the application after the release is successful.Program.

So far, your database has been successfully released to the Godaddy host and can be used at any time.

Godaddy remote database connection
To remotely connect to a database, Godaddy needs to download the following software:
Common database management software:

MySQL query Browser
Microsoft SQL Server Management studio Express
After the download and installation, you can connect to your database. The connection settings are as follows:

Host Name or server
You can refer to this method for the name of the server your database is stored on:
Http://bbs.idcspy.com/thread-18582-1-1.html
Port
If the port is required, enter the following:
MySQL: 3306.
MSSQL: 1433
User Name
Database username.
Password
Database Password. (You can modify the settings)
Database
The database you want to connect.
Document. writeln ("