Godaddy's ASP space can publish ms SQL database through DPW

I purchased Godaddy's deluxe some time ago.
Plan host, large and small websites are all put up at once, nearly 10, running for nearly a month, not bad, so far no downtime has been found, and the shared IP address is always positive.
Often, not blocked. In addition, there is good news that Godaddy has comprehensively upgraded the Host Program
Plan's storage space is upgraded from 150 GB to 1500 GB, and the traffic is also upgraded from GB to GB, which is very cost-effective. However, Godaddy also has a headache, that is, Ms.
SQL database.

Previously, the focus has been on Godaddy's space, traffic, domestic access speed, and after-sales issues. These seem to be good, while ignoring Ms.
SQL Database Import problems. I created a ms in the background.
SQL database, but found that the release cannot be remotely controlled, nor can it be directly restored by backing up the Bak. You must convert it to CSV to import the database. Very troublesome, and the chances of successful operations
Also small. Finally, you can purchase MS from another service provider.
Then, the web page is stored in the Godaddy space for remote connection. The answer is no. Godaddy does not allow external connection to the ms SQL database. This is big.

I searched for a lot of information online and finally got a better solution. Publishing a database using the database Publishing Wizard, which is released through Microsoft database Publishing Wizard.

To release the database successfully, 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 can be installed without one. Pay attention to the order, it is best to install according to the above 1, 2, 3, 4, 5 order.

Next we will release the database in DPW. You can refer to the original English operation steps here, or follow these Chinese steps.

Use DPW to publish your database

1. Open the DPW client. If the welcome page appears, select"The next entry will not be displayed"Box.
2. ClickNext step.

3. InSelect source serverEnter the connection information of your local SQL Server.

4. Complete connection information, clickNext step. EnterSelect DatabaseThe local database file is displayed.

   Note:If you don't see the database you want to releaseReturnTo selectSource Selection ServerPage, and do not change the connection information before returning to this page. If this step does not work, contact the server owner for help.

5. Select the database you want to publish. If your database contains prohibited objects, such as full text catalogs and assemblies, or you do not want to publish all objects, do not selectScript all objects in the selected Database.
   
6. PointNext step.
7. If you do not publish all objectsSelect object type.
   If you have not released all objects
   1. Select the object to be released.

   2. PointNext step. Enter the object selection type screen. If you want to discard and select all objects, clickSelect All.

   3. Select an object and goNext step. Repeat the previous operation guide to enterSelect an output locationPage.
      
8. DisplaySelect output locationPage (translation is too difficult. Let's explore the translation here)

9. SelectPublish to shared hosting providerOption. Select the appropriateProviderAndTarget DatabaseFrom the drop down lists.
   
10. If you have not yet configured a connection or need to make a new connection, pressMore.Hosting ProvidersDialog displays.
    If you have not configured a connection
    1. PressNew.Provider ConfigurationDialog displays.
    2. Enter the following values:

       Name:

       Enter any name to represent the connection to the hosted service. You will enter names for specific databases later.

       Web service address:

       Enter
       The URL for the Publishing Service. The URL can be found in
       Database information section of your hosting control panel.

       Note:
       The service requires a secure (https) connection to protect data. If
       You attempt to connect using a non-secure connection, the connection
       Will fail and you will be prompted to use a secure connection.

       User name:

       Enter your FTP account user name.

       Password:

       Enter your FTP account password.

       Note:
       Checking "Save Password" causes the application to store your password
       Locally. If this is a public or shared machine, this may not be
       Secure choice.

    3. To enter a database, pressNew. This displaysDatabaseDialog.
    4. Enter
       The appropriate configuration values. The configuration values can be
       Found in the database information section of your hosting Control
       Panel.

       Server Name:

       Enter the full path to the database server.

       Database Name:

       Enter the name of your hosted database.

       Note:
       The database must be owned by the FTP account entered in the provider
       Configuration. If you have multiple hosting accounts, be sure to use
       The correct credentials when refreshing the Publishing Wizard.

       User name:

       Enter your database user name. This is the same user name used to access the SQL Web Manager.

       Password:

       Enter your database password. This is the same password used to access your SQL Web Manager.

       Note:CheckingSave PasswordCauses the application to store your password locally. If this is a public or shared machine, this may not be a secure choice.

    5. ClickOK
       To complete the database set-up. Repeat this step for each database you
       Want to configure. If you have multiple databases owned by a single
       Hosting account, they can all be entered under a single hosting
       Provider entry.
    6. When you have completed entering databases, clickOKOnProvider ConfigurationDialog to return toHosting ProvidersList. You can test your connection settings by pressingTest. This feature validates the connection to the Web service but does not test connectivity to the database itself.
    7. ClickOKTo return toSelect an output locationDialog. If the appropriate provider and database are not selected, select them in the drop down lists.
    8. ClickNextTo advance toSelect publishing options
       Screen. Before this page is displayed, the Service validates
       Configuration settings by connecting to the Publishing Service and
       Target database. If a connection cannot be established, an error
       Message displays and the application remains onSelect an output locationScreen.
11. TheSelect publishing optionsPage is pre-populated with the appropriate default values. In most cases, these do not need to be modified.

    Drop existing objects in script:

    If True,
    The wizard checks if a published object exists in the database and, if
    Found, drops the existing version before publishing.

    Note:Any data contained within dropped objects will be lost.

    If False,
    The wizard does not drop existing objects before inserting or modifying
    Their structure. If an object of the type and name specified already
    Exists, the wizard proceeds directly to data insertion. If the object
    Does not exist, it will be created.

    Note:
    If the target database contains an object of the same name and type
    With a different structure (for example, a table with a different
    Number of columns), a publishing error may occur. Certain Conditions
    May not report an error (for example, the database being published
    Contains a table with fewer columns than the existing table). In such
    Cases, the published database will not exactly match the local database.

    Publish using transaction:

    If True, The database is published as a single transaction. If an error occurs, all changes are rolled back.

    If False,
    Published changes are committed as they are published. If an error
    Occurs, the database may be left in a partially published state.

    Schema qualify:

    If True, Objects are fully schema qualified in the script.

    If False, Only the object name is used. It is recommended this option be True.

    Script for target database:

    Specifies
    The version of the target database. This must match the server version
    Or publish will fail. The Wizard sets this value to the correct
    Version.

    Types of data to publish:

    This section specifies what type of information to publish.

    SchemaOnly publishes the structure of objects.

    DataOnly populates tables.

    Schema and DataPublishes the structure of objects and populates tables.

12. ClickNextTo advance. This step brings upReview SummaryPage, which displays the selected options and configuration. This is the last chance to review before publishing begins.

13. ClickFinishTo begin publishing.

TheDatabase publishing SS
Screen tracks the progress of the publish. Based on the options
Selected, the wizard displays some combination of the following steps:

Gathering list of objects to script:

The
Wizard is communicating with your local SQL Server and determining what
Objects must be scripted, including any objects you selected and their
Dependencies.

Connecting to Web Service:

The wizard is connecting to the web service and establishing a publishing session.

Scripting objects:

The wizard is refreshing Ming preliminary scripting of the objects to be published.

Processing:

The
Wizard is completing local scripting of an object and transmitting it
To the web service. The web service is executing the script against
Your hosted database server. The status message updates based on
Specific object being published at a given instance.

The
Amount of time to publish a database varies based on complexity of
Database, number of objects, and the amount of data in tables. Most
Databases complete publishing in under 30 minutes.

It is possible to abort processing at any point by pressingStop. If an error occurs, a red link to more details is provided inMessageColumn. If publishing is aborted or an error occurs, you can useBackTo move back through the screens and modify settings.

If publishing succeeds, pressCloseTo close the application. Your database is now transferred to the hosting server and ready for use.