CODEWITHSUNDEEP
sqlsql-serverdatabasesql-server-2008ssms
SParc
SParc

Reputation: 1779

How to get SQL Query for the changes in database schema?

I am not a database programmer but I have a big database that contains many tables. My database programmer left the project that we were doing together. So all the load came upon me for completing that project. On my local server I made many changes to my app's database schema. I noted all the changes in the notebook to implement them on main server. But I want a quick method to update database on main server with those changes. So I was wondering if there exists any way of generating query for only those changes that are done on local server using SQL Server Management Studio or some other tool?

Upvotes: 1

Views: 189

Answers (1)

Colin Edwards
Colin Edwards

Reputation: 116

A SQL compare tool should provide you with a good solution to start with

DBComparer provides a free alternative to Redgates [SQL Compare] (http://www.red-gate.com/products/sql-development/sql-compare/)

Going forward you should keep a source controled version of the database.

Our company also stores the db version in the database and uses a versioned update script whenever a live db needs updated.

Upvotes: 1

Related Questions