In the past I have been a big fan of Platinum's ERwin. Essentially a
case tool that graphically displays your databases, this allows you to
reverse engineer existing databases, create new databases and modify
existing databases. You could take an Erwin model of a current database and
compare it to another, applying changes if needed.
I also used it in conjunction with Visual Source safe and applied
version control with it etc.
Available from all good suppliers ( or check out their web site
Downside ( of course ) cost in the region of GBP 3000
>Does anyone know of any tool which can be used to compare the contents
>and properties of 2 MS-SQL databases? There may well be something in the
>Enterprise Manager or some SQL script that could do this but as yet we
>haven't been able to find it. We need something like this to check
>development databases before updating using them in our production