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
NOTE: Microsoft SQL Server 2008 databases do not support DPS or DPW.