Database Publishing Wizard uses the following modes to deploy an SQL database:
Script mode: In this mode, Wizard generates a single SQL script file that a user can run manually on the target server for recreating the database schema and contents.
Web service mode: In this mode, Wizard connects to a Web host environment service and copies the content of a source database into a target database directly.