SQL script to show addition to tables

Question

Hey all

I have a 2 MS SQL 2005 databases,a TEST and DEV database. Now our developer added some extra columns,tables etc in the DEV database.This created differences in the TEST database.is there a script i can write tha can tell me what the changes where in the DEV database between certain dates...i found a couple of tools but they are quite basic and dont really generate change scripts etc. Also tried the change script function in management studio but it seems to be working when the change is first made and not later. Appreciate your thoughts.

A.

Answer 1

What you need is a way to manage changes to your database schema and then apply them in a controlled and consistent manner. Moreover, you need a single authoritative source for the database schema.

For all this, check out Wizardby:

Answer 2

redgate SQL Compare is a good tool to check for differences between databases and even sync them.

However, if you need to do this for free, try this: within in SQL Server Management Studio do the following:

1) script the entire schema of TEST to a file, look here if you don't know how
2) repeat step #1 but for the DEV database
3) diff the files using something like Beyond Compare, should have a 30 trial

Answer 3

I wrote dbscript, and one of its features is to compare two database schemas and create a migration script.