If your dealing with SQL Server and need to do some database replication, you should know that its a complex process and there's different types of replication.
In 2005, I put together this PDF document to assist customers with understanding the various types of replications and the advantages of selecting that option. Use this information as an aid when talking to a DBA on specifically the type of replication you need.
I found this information when researching replication:
If you need to synchronize a small number of tables, you might be able to do the job by running in Query Analyzer a simple batch that contains for each table one UPDATE command that replaces, but doesn't change, the table values on the Publisher server and kicks off the data synchronization process. But if you need to synchronize a large number of tables (more than 10), it is more efficient to create a DTS package that runs the forced replication process.
Computer PDF Documents that I collected
|SQL Server Replication||General information about the various steps to setup SQL Server Replication.|
|MySQL Date Time||A Very handy Date Formating variables chart for MySQL.|
|Tip Box||How to create a Tip Box using Tables instead of HTML|
|Tandy 1000sx||The Tandy 1000 as described in a 1987 Radio Shack Catalog|