O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required