How to generate incremental script to sync databases?

[Guest_imported]

Suppose there is a production database running.
And I have a testing database and made a lot of changes on the testing databse.
Now, I want to sync these 2 databases (make database structure of the production db the same as the testing one).

How can generate the script to sync the production database?
(I don't want to re-create the production database!)

Thanks!

 

[aalmeida]

You have to use a change control policy to be able to do that there is good example of it at:

http://www.swynk.com,

it is to big to post here thogh AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"