Tuesday, July 17, 2012

Use Database Publishing Wizard tool in VS 2010

In Visual Studio 2010, "SQL Database Publishing Wizard" feature should be installed as one component named Microsoft SQL Publishing Wizard 1.4 during the installation.

It should be located at the path:  
C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.4\SqlPubWiz.exe

If not exist, you can extract the SQL Database Publishing Wizard tool in the WCU\SQLPub folder in the installation media and then try the installation of tool by clicking on the SqlPubWiz.msi file.