Microsoft SQL Server

Migration

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

  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.

This modified text is an extract of the original Stack Overflow Documentation created by the contributors and released under CC BY-SA 3.0 This website is not affiliated with Stack Overflow