Chapter 14. Transferring Data to and from SQL Server

In a standard business environment, it is quite common to have different system platforms, different operating systems, heterogeneous networks, and different database systems. Linking existing data from different sources is a convenient way to work with heterogeneous data to gain data consistency through the company without creating any data redundancy. However, in some cases, you might need to transfer data from one system to another.

Importing and exporting data is a common task for a database administrator, and it is not our intention to cover this subject in detail. However, as a database programmer, you should know the basics of importing and exporting data, and this chapter will teach ...

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.