>I need to find a way to extract a table from a database and synchronize that into another server. Basically, all servers have the same database. We have a production site, backup site, test site, etc. So, sometimes, I may need to take only one table from the production site and update it on a remote site.
Check out
http://www.red-gate.com/products/SQL_Data_Compare/index.htm