Generate and Publish Scripts Wizard (Introduction Page)
Use this wizard to create Transact-SQL scripts of the objects in a database. The database can either be on a local instance of the SQL Server Database Engine, or in SQL Azure. Create scripts for an entire database or limit it to specific data and database objects You can save scripts to the location of your choice and later use them to generate the objects and data in a database on either a local instance of the Database Engine, or in SQL Azure.
You can also use the wizard to publish the selected database objects and data directly to a remote Web service that was build by a Web hoster using the Database Publishing Services project from the SQL Server Hosting Toolkit on CodePlex
Functionality from the Publish Database Wizard has been added to this wizard. The Publish Database Wizard has been discontinued. To use the publish feature, you must have access to a Web service that was installed by using the SQL Server Database Publishing Services. For more information, see the SQL Server Database Publishing Services download page.