CODEWITHSUNDEEP
sqlsql-server-2005
ediblecode
ediblecode

Reputation: 11971

Creating a specific database deployment script

I have been asked to migrate a schema from our testing area into our staging area.

As someone that has never done this before my first instinct would be to paste every script into one large script and hope that I have done it in the right order.

Is there a better way? If anyone could point me to this information I'd be very grateful.

Upvotes: 1

Views: 45

Answers (1)

Jahan Zinedine
Jahan Zinedine

Reputation: 14874

You can use the Generate Script option when right clicking on database in Management Studio and even choosing to export data to the file in last step by clicking the Advanced button.

A tutorial can be found here How to: Generate a Script (SQL Server Management Studio)

Upvotes: 3

Related Questions