Selecting Target Script File or Deployment Database

The Schema Wizard can either generate SQL script, which you can use later ,or directly deploy the selected schema to a different database or server. If you choose to deploy schema into a target database, you still can specify to generate a backup script file during this operation.

To export a schema into a script file:

1. Choose Export to Script File radio button.
2. Enter the file name. You can also use the Browse button to locate the file or directory.
3. Press Next button.

To deploy a schema to a different database or a different server:

1. Choose Deploy to Database radio button.
2. Choose a target server connection from the Connections list or press New button to create a new connection.
3. Choose a target database from the Database list.
4. Press Next button.