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.
Kaynak:
Bu aracın kullanımını anlatan türkçe başka bir makale:
SQL Server Database Publishing Wizard Ile Veritabanı Yayınlama
http://www.omercebi.com/IcerikDetay-sql-server-database-publishing-wizard-100.aspx
http://www.delipenguen.com/2011/11/sql-serverda-sql-script-ile-yedek-alma/
Deploying a Local Database to a Remote Web Host
http://www.delipenguen.com/2011/11/sql-serverda-sql-script-ile-yedek-alma/
Deploying a Local Database to a Remote Web Host
Hiç yorum yok:
Yorum Gönder