Every now and then you find this tools that you can't live without. I've been using SQL Compare and SQL Data Compare for a year now and I can't quantify how many hours of work these tools have saved for me. SQL Compare is a tool that compares SQL Server databases and tells what differences there is with the possibility to synchronize them to have the same tables, views, procedures and so on. SQL Data Compare on the other hand compares the contents of two SQL Server databases. In most project that I'm working on we have a database for unit testing, one for developing, a testing database and finally the production database. It is not uncommon for developers to even have their own local database so that they more easily can work offline. I wouldn't even think about managing this without a tool like SQL Compare, so if you haven't tried them out yet, I have only one advice: Go get them now!