CHAPTER 7
Exporting Data from SQL Server
Getting data into SQL Server can be a major challenge faced by a developer or a DBA. Yet there are frequent occasions when data needs to be pushed in the other direction—out of SQL Server and into another program or system. This aspect of data integration also has its tricks (which you need to know) and pitfalls (which you need to know how to avoid). This chapter looks at some of the main methods of sending data from SQL Server into other environments. Fortunately, you have are two main advantages when exporting data from SQL Server as compared to importing it:
- You possess complete knowledge and control ...
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.
