Horje

MS SQL Server - Microsoft SQL Server - Migration
Start
  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. 

    • Read Article
    https://develop.horje.com/learn/1434/reference

     

    Horje