An awful lot of the data that you will be called upon to load into SQL Server is probably already stored in a relational database. While you can certainly export from most of the currently available commercial SQL-based databases into a text or XML file, and from there into SQL Server, there are also standard ways of connecting directly to most RDBMSs (relational database management systems) and then extracting data from them into the Microsoft RDBMS. In this chapter, therefore, we will be looking at some of the available ways of ingesting and linking to data from the following:
  • Oracle

  • DB2

  • MySQL

  • Sybase

  • Teradata

  • PostgreSQL


Source Database Extension Pack Oracle Database Connection Manager Enterprise Edition 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Adam Aspin 2012

Authors and Affiliations

  • Adam Aspin

There are no affiliations available

Personalised recommendations