How to generate migration scripts
- Click Right Mouse on Database you want to migrate then ->
- Wizard will open click
Next then chose objects you want to migrate and click
Next again, then click
Advanced scroll a bit down and in
Types of data to script choose
Schema and data (unless you want only structures)
Click couple more times `Next` and `Finish` and you should have your database scripted in `.sql` file.
run `.sql` file on your new server, and you should be done.