Abstract

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

Keywords

Migration Drilling Editing 

Preview

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