Skip to content
DevTut

Migration

How to generate migration scripts

Section titled “How to generate migration scripts”
  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

  • 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.