SQL Database Publishing wizard with SQL Server 2008

visual-studio-2008 sql-server-2008 export publishing wizard
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.

Related questions

How can I automate the "generate scripts" task in SQL Server Management Studio 2008?

I'd like to automate the script generation in SQL Server Management Studio 2008. Right now what I do is : Right click on my database, Tasks, "Generate Scripts..." manually select all the export options I need, and hit select all on the "…

Read More
beginner's tutorial for report viewer?

I am using VSTS 2008 + C# + .Net 3.5 + SQL Server 2008 + ASP.Net + IIS 7 to develop web application. Any quick and easy to learn tutorial for report viewer -- I want to generate report based on data from SQL Server 2008. Basic design and …

Read More
How to debug a script component in SSIS

It's simple but I can't make it work, and I read in so many places a lot of solutions but nothing worked for me. How can I accomplished this? Note I put a break point in my code and ran …

Read More