CODEWITHSUNDEEP
sqlsql-serverdatabasedatabase-designsql-server-2008-r2
socialMatrix
socialMatrix

Reputation: 1443

Generating script for database schema changes

I have two database schema. I need to generate the script consisting of the difference. How do I do this?

Basically, I had original schema that I modified. So I need the script for what changed. Which tables got dropped and relationships are broken etc...

P.S. I do not have red gate.

Upvotes: 0

Views: 106

Answers (1)

Icarus
Icarus

Reputation: 63956

Use the Schema Compare feature in Visual Studio:

Main Menu --> SQL --> Schema Compare --> New Schema Comparison

And go from there...

It may prompt you to download the SQL Server Data Tools from here if you don't already have it.

Note: I am no sure if this works in the Professional Version. It's certainly available in the Ultimate edition.

Upvotes: 1

Related Questions