You can generate scripts to migrate the database structure, data, or both between SQL Server and Azure SQL instances.
This section explains how to create these scripts by using the Generate Scripts Wizard in dbForge Studio for SQL Server and how to automate their generation with Windows Task Scheduler.
Note
You can generate scripts for local, remote, or Azure SQL databases.
The migration process includes the following steps:
1. Generate a script for the source database.
2. Connect to the target server, and make sure it has a database with the same name as the source.
3. Execute the generated script on the target server.