Microsoft SQL Server How to generate migration scripts


Example

  1. Click Right Mouse on Database you want to migrate then -> Tasks -> Generate Scripts...

enter image description here

  1. 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)

enter image description here

  1. Click couple more times Next and Finish and you should have your database scripted in .sql file.

  2. run .sql file on your new server, and you should be done.