>SQL Compare quickly and easily compares the structures of two database, tells you what's different, generates a script, and allows you to run it right there. I'd use that to move my DB changes from dev to test to prod, etc.
>
>SQL Data Compare does that same, but for data. Instead of working with database backups it would generate CRUD (well, CUD I guess) statements.
>
>Both well worth the money.

That is interesting. Do you know if it gets a hold of new indexes, full text indexing settings, files, etc.? We have a situation where there is this big database which is difficult to synchronize in our test and dev environments because of its size. So, we do it once every 10-12 months approximately. Such tool might be interesting for that. The download takes about the entire weekend to be processed included the update into the test and dev servers. As for my own corporate data, I do not have that problem yet as from within one click from my PC, I can synchronize everything entirely as is within a few minutes. But, the size is not the same. This is why when the database gets really big, instead of taking an entire copy of it, transferring it across the wire and moving it into the other locations is a big task.