CHAPTER 5
SQL Server Sources
In this book, we look at importing data from several relational databases, and some of the ways in which they can be used as data sources for SQL Server. Yet there is one relational database we have not talked about, and that is SQL Server itself. So to continue our “data source tour,” let’s examine at some of the ways in which you can transfer data between SQL Server databases.
This overview includes:
- Ad hoc querying external SQL Server instances
- SQL Server linked servers
- Bulk loading of data from one SQL Server database to another SQL Server database
- Loading data from older versions of SQL Server into SQL Server ...
Get SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools 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.
