DevTut

# Migration

# How to generate migration scripts

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

enter image description here (opens new window)

  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 (opens new window)

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

    • ← Table Valued Parameters →