Microsoft SQL Server Migration How to generate migration scripts

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

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.



Got any Microsoft SQL Server Question?