Applying Schema change.

Hi.
One of teh major problems we are facing is happening when we change the data
base structure for new releases and we want to dispatch this to existing
clients.
1.Is there a utility that allow us to apply the new schema on an exiting
data base.
2. Is there also a utility that will list records that are imcompatible with
the new schema (constraints violations ,etc...)
thanks1.
http://www.innovartis.co.uk/database_dbghost_home.aspx
http://www.red-gate.com/SQL_Compare.htm
2. I'm not aware of any. Typically I would expect to develop my own
transformations to align the legacy data with the new schema.
David Portas
SQL Server MVP
--