SQL Database Publishing wizard with SQL Server 2008

pupeno picture pupeno · Sep 7, 2009 · Viewed 37.1k times · Source

I'm desperately looking for SQL Database Publishing wizard. I've download it but it seems to require SQL Server 2005. According to http://blogs.msdn.com/webdevtools/archive/2007/10/15/sql-database-publishing-wizard-is-now-in-visual-studio-orcas.aspx it comes with Visual Studio 2008, but my Visual Studio 2008 Professional doesn't have that menu item.

Any ideas how can I get the SQL Database Publishing wizard working with SQL Server 2008.

Answer

Saman picture Saman · Dec 23, 2009

I found the solution online. Here is the steps to solve the issue in case any one else having the same problem. Thanks.

  1. Open Control Panel and go to Add or Remove Programs.

  2. Right-click the component 'Microsoft Sql Server Database Publishing Wizard 1.3' (or 'Microsoft Sql Server Database Publishing Wizard 1.2' if this older version was installed due to (b) above), and then click Uninstall. Wait for uninstallation to finish.

  3. Run SqlPubWizInstaller.exe from http://go.microsoft.com/fwlink/?LinkId=119368 to re-install 'Microsoft Sql Server Database Publishing Wizard 1.3'. You can verify that it was installed by looking in Add or Remove Programs.