Publishing a database using the publishing a database using

This tutorial shows you how to publish a database using the database Publishing Wizard (DPW ).

To publish your database using the DPW

1. LaunchDatabase Publishing WizardClient. If the welcome screen displays, checkDo not show this starting page againBox.
2. ClickNext.

3. OnSelect source serverScreen, enter the connection information for your local SQL Server.

   Note:This is not the same information as that used for your hosted server. If you are publishing from an instance of SQL server running on your desktop or local network, you useSpecify Server InformationSection. If you are publishing from a remote database, connect via a connection string. For specific connection information, contact the database server owner.

4. Once you have entered the connection details, clickNext. This step brings upSelect DatabaseScreen, displaying a list of all databases available on your local server.

   Note:If you do not see the database you want to publish, pressBackTo return toSelect source serverPage and then return to this page without changing connection details. If this step does not work, contact the server owner for support.

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, uncheckScript all objects in the selected Database.
6. PressNext.
7. If you are not publishing all objects,Choose objects typeAppears.
   If you are not publishing all objects
   1. Select the object types to be published. You will be able to pick specific objects of each type on later screens.

   2. ClickNext. This step brings upChooseScreen for each object type selected (for example, tables and views). If you want to publish all objects of a given type, clickSelect All.

   3. Once you have selected all objects to be published, pressNextTo advance. Repeat this step until you reachSelect an output locationScreen.
8. TheSelect an output locationScreen appears.

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 the 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 a 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 ing 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. ClickOKTo 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 optionsScreen. before this page is displayed, the Service validates the configuration settings by connecting to the Publishing Service and the 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 but 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 SSScreen tracks the progress of the publish. Based on the options selected, the wizard displays some combination of the following steps:

<Script language = "JavaScript" src = "http://book.book560.com/ads/ads728x15.js" type = "text/JavaScript"> </SCRIPT>

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 the specific object being published at a given instance.

The amount of time to publish a database varies based on complexity of the 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.