SQL Database Publishing wizard with SQL Server 2008

exportpublishingsql-server-2008visual-studio-2008wizard

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.

Best Answer

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

Open Control Panel and go to Add or Remove Programs.
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.
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 Solutions

Sql-server – How to check if a column exists in a SQL Server table

SQL Server 2005 onwards:

IF EXISTS(SELECT 1 FROM sys.columns 
          WHERE Name = N'columnName'
          AND Object_ID = Object_ID(N'schemaName.tableName'))
BEGIN
    -- Column Exists
END

Martin Smith's version is shorter:

IF COL_LENGTH('schemaName.tableName', 'columnName') IS NOT NULL
BEGIN
    -- Column Exists
END

Sql-server – Why won’t Visual Studio 2008 create .mdf files with SQL Server 2008 Developer installed

I ran into this problem too on 64-bit Windows 7 (using 64-bit SQL Server Express 2008).

There are two methods of fixing this problem referenced in the Microsoft Support Knowledge Base article:

1. Workaround

To work around this problem, uninstall the 64-bit version of SQL Server Express 2008, and then install the 32-bit version of SQL Server Express 2008.

If you don't want to do the uninstall/install, then try the Hotfix method below.

2. Hotfix

A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that this article describes. Apply it only to systems that are experiencing this specific problem.

Although the article itself doesn't include a link to the hotfix, you can get it here: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957944

Best Answer

Related Solutions

Sql-server – How to check if a column exists in a SQL Server table

Sql-server – Why won’t Visual Studio 2008 create .mdf files with SQL Server 2008 Developer installed

Related Topic