Help Center

Version 2.0

• Windows Hosting
• Working with Databases

Help Center Search

Related Articles

• Connecting to a Microsoft SQL Server Database Using ASP/ADO
• Connecting to a MySQL Database Using ASP/ADO
• What MySQL Server Features are Disabled on my Shared Hosting Account?
• Do you restrict any features in MySQL 4.1/5.0?
• What is MARS and how do I use it?
• What are the major differences between MySQL 4.0 and 4.1/5.0?
• Is there a size limit on MS SQL databases?

What version of SQL Server is supported by the Database Publishing Service and Database Publishing Wizard?

The Database Publishing Wizard (DPW) client works with all local versions of SQL Server and supports publishing to both 2000 and 2005 databases. The DPW client automatically sets the Script for target database version to the correct version when publishing to the hosted Database Publishing Service (DPS).

When publishing to SQL Server 2000, transactions are not supported, and it is not possible to publish SQL Server 2005 specific data types, such as XML.

For additional information about the Database Publishing Service and the Database Publishing Wizard, see the following articles:
Limitations of the Database Publishing Service in the Shared Hosting Environment
Publishing a Database Using the Database Publishing Wizard

• Not helpful
• Somewhat helpful
• Helpful
• Very helpful
• Solved my problem