Tools for Transferring Data Using SQL Server 2000
SQL Server 2000 offers many different choices to transfer data. Every tool has advantages and disadvantages. You can use the following examples as guidelines to select the data distribution tool to use:
Using distributed queries, you can directly access data from different servers. Chapter 15, "Working with Heterogeneous Environments: Setting Up Linked Servers," covers distributed queries in detail.
You can use replication to copy data from one server to another, on demand or at regular intervals. If you need to distribute data to mobile users, and they need to modify data locally, merge replication is an excellent solution. Transactional replication is a very efficient mechanism to distribute ...
Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
