none
Database Publishing Wizard in VS 2010 Professional

    Question

  • There is another post on this forum about not being able to find the Database Publishing Wizard in VS 2008. I am using Visual Studio 2010 Professional and I cannot find or use this wizard, but would really like to have it as it seems ideal for what I want to do and I'm not interested in a Command Line option. I have connected to my database, my tables and data are all there, but when I right click on the database, I am not given a choice of "Deploy to Provider". It's not grayed out, its just not there. From all the blogs I have read this .exe should be part of VS 2010. Has any one else had this problem and does anyone know what I can do to resolve it?

    Wednesday, August 11, 2010 6:54 AM

Answers

  • Hi IBISDev,

    As far as I know, "SQL Database Publishing Wizard" should be one feature named "Publish to Provider" in Visual Studio IDE as the following screen shot:

    http://2efoga.bay.livefilestore.com/y1pv7OUy5O4eqhr-nNI3_nnZAVCeNPcFHa1PD4vRCXF0jjyr03VqT94sSk2JzwXpRl4sphAKy9C5BxMcwbwhsMi0gSzw4QSlTw-/SQL%20Database%20Publishing%20wizard.png?psid=1

    Based on your description, it looks like that you're looking for "Publish to Provider" feature in Server Explorer of VS2010 Professional IDE.

    I have Visual Studio 2010 Ultimate installed on your machine. When I right click on any database in Server Explorer, I can find "Publish to Provider" option listed.

    After some search, I found:
    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\Microsoft SQL Server\90\Tools\Publishing\1.4\sqlpubwiz.exe.

    For your concern, could you please help me to check whether you can find Microsoft SQL Publishing Wizard 1.4 listed via Control Panel >> Add\Remove Programs (Windows Server 2003 and Windows XP) or Programs and Features (Windows Vista and Windows Server 2008)?

    If no, you can extract the SQL Database Publishing Wizard tool (which is in the WCU\SQLPub folder in the installation media) and then try the installation of tool alone by clicking on the SqlPubWiz.msi file.

    If yes, I would suggest you to repair your Visual Studio 2010 Professional Edition.

    As one workaround, you can try to add it as one external tool via Tools menu >> External Tools. This at least brings the wizard up, although you will need to re-configure the connection string.

    If all the suggestions don't work, you might need to run Visual Studio 2010 Uninstall Utility to completely remove and reinstall it again.

    Hope this helps! If you have any concern, please feel free to let me know.

    Best regards,
    Yichun Chen
    MSDN Subscriber Support in Forum
    If you have any feedback on our support, please contact msdnmg@microsoft.com
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by IBISDev Wednesday, August 11, 2010 4:55 PM
    Wednesday, August 11, 2010 9:38 AM
  • Yichun,

    Thank you for your excellent and thorough response. I tried everything you suggested and searched on every keyword or file name on my hard drive that I thought might find Database Publishing Wizard, but it obviously wasn't there. I reinstalled VS 2010 and made sure that Database Publisher Wizard 1.4 was on the list of modules to install and then checked the install log afterward. After the install I now get the "Publish to Provider" option when I right click my DB in Visual Studio 2010.

    My initial installation of Visual Studio was not quite traditional which may be why this Wizard was not installed. I started first with a trial copy of Visual Studio to do my early development and then I signed up with Web Spark and installed Visual Studio 2010 from that site. I re-installed the same version this time, but I was obviously more observant and was looking for a particular feature.

    Thanks again for your help and taking the time to provide such a detailed response.

    Bob Blasingame

    • Marked as answer by IBISDev Wednesday, August 11, 2010 4:55 PM
    Wednesday, August 11, 2010 4:54 PM

All replies

  • Hi IBISDev,

    As far as I know, "SQL Database Publishing Wizard" should be one feature named "Publish to Provider" in Visual Studio IDE as the following screen shot:

    http://2efoga.bay.livefilestore.com/y1pv7OUy5O4eqhr-nNI3_nnZAVCeNPcFHa1PD4vRCXF0jjyr03VqT94sSk2JzwXpRl4sphAKy9C5BxMcwbwhsMi0gSzw4QSlTw-/SQL%20Database%20Publishing%20wizard.png?psid=1

    Based on your description, it looks like that you're looking for "Publish to Provider" feature in Server Explorer of VS2010 Professional IDE.

    I have Visual Studio 2010 Ultimate installed on your machine. When I right click on any database in Server Explorer, I can find "Publish to Provider" option listed.

    After some search, I found:
    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\Microsoft SQL Server\90\Tools\Publishing\1.4\sqlpubwiz.exe.

    For your concern, could you please help me to check whether you can find Microsoft SQL Publishing Wizard 1.4 listed via Control Panel >> Add\Remove Programs (Windows Server 2003 and Windows XP) or Programs and Features (Windows Vista and Windows Server 2008)?

    If no, you can extract the SQL Database Publishing Wizard tool (which is in the WCU\SQLPub folder in the installation media) and then try the installation of tool alone by clicking on the SqlPubWiz.msi file.

    If yes, I would suggest you to repair your Visual Studio 2010 Professional Edition.

    As one workaround, you can try to add it as one external tool via Tools menu >> External Tools. This at least brings the wizard up, although you will need to re-configure the connection string.

    If all the suggestions don't work, you might need to run Visual Studio 2010 Uninstall Utility to completely remove and reinstall it again.

    Hope this helps! If you have any concern, please feel free to let me know.

    Best regards,
    Yichun Chen
    MSDN Subscriber Support in Forum
    If you have any feedback on our support, please contact msdnmg@microsoft.com
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by IBISDev Wednesday, August 11, 2010 4:55 PM
    Wednesday, August 11, 2010 9:38 AM
  • Yichun,

    Thank you for your excellent and thorough response. I tried everything you suggested and searched on every keyword or file name on my hard drive that I thought might find Database Publishing Wizard, but it obviously wasn't there. I reinstalled VS 2010 and made sure that Database Publisher Wizard 1.4 was on the list of modules to install and then checked the install log afterward. After the install I now get the "Publish to Provider" option when I right click my DB in Visual Studio 2010.

    My initial installation of Visual Studio was not quite traditional which may be why this Wizard was not installed. I started first with a trial copy of Visual Studio to do my early development and then I signed up with Web Spark and installed Visual Studio 2010 from that site. I re-installed the same version this time, but I was obviously more observant and was looking for a particular feature.

    Thanks again for your help and taking the time to provide such a detailed response.

    Bob Blasingame

    • Marked as answer by IBISDev Wednesday, August 11, 2010 4:55 PM
    Wednesday, August 11, 2010 4:54 PM
  • Hi Bob,

    It's my pleasure!

    I'm so glad to hear that your issue is solved.

    Have a nice experience of Visual Studio 2010.

    Best regards,
    Yichun Chen
    MSDN Subscriber Support in Forum
    If you have any feedback on our support, please contact msdnmg@microsoft.com
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Edited by YiChun Chen Thursday, August 12, 2010 6:22 AM typo
    • Proposed as answer by TennChris1 Tuesday, January 04, 2011 11:15 PM
    Thursday, August 12, 2010 6:22 AM
  • I had the same problem with SQL Publishing Wizard 1.4 not installed.

    To solve it went into the Add/Remove features choice in the Visual Studio 2010 setup.  There I choose to uninstall Visual Web Developer only.  Once complete, I reinstalled it.  This worked just great and didn't take too long. Easier and faster than uninstalling / installing the entire Visual Studio 2010!

    Conversely, I did try to run the SqlPubWiz.msi file earlier.  This install program has a restriction in it that it must be called by the Visual Studio setup program.

    Also previously, I did a full repair of Visual Studio (this takes as long as installing it) and that did not reinstall the Publishing Wizard. (Note: I did have the Publishing Wizard installed earlier - but am pretty sure I had uninstalled via Control Panel; Programs and Features).

    Hope this saves you a bunch of time.

    Tuesday, January 04, 2011 11:28 PM