In one of my recent projects, we have a team of developers and some work remotely and make database changes including tables, stored procedures and test data. It was a pain to get all database changes done from DEV database to TEST and PROD databases until I found RedGate's fantabulous tools - SQL Compare and Data Compare.
Intially it took me couple of hrs to learn the tools but now in minutes I can sync my database changes, SPs, and including data and the best part is these tools are a part of SQL Server menus.
Check them out and let me know how you like them. Trust me, if you do lot of data sync, you would not regret this and you would dump your DBA right away.
Try SQL Compare here:
http://www.red-gate.com/products/SQL_Compare/index.htm
SQL Data Compare here:
http://www.red-gate.com/products/SQL_Data_Compare/index.htm
Are you using these products? I would like to get your feedback on all RedGate's SQL Software products.