Microsoft SQL Server Tutorial => How to generate migration scripts

Download Microsoft SQL Server (PDF)

Fastest Entity Framework Extensions

Example

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

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)

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.

PDF - Download Microsoft SQL Server for free

Previous Next

Get monthly updates about new articles, cheatsheets, and tricks.