Advanced Scripting Options let you select Server version for which you want to generate script. Select your destination Server’s version from “Script for Server Version” drop-down list. Make sure you also select ” Schema and data” from “Types of data to script” drop-down list. Click OK then Next button to proceed to next step.
Generate and Publish Scripts Wizard will now create T-SQL script for entire database objects and save at given location.Upon successful script generation, you will see “Success” written against all database objects.