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
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Adam Aspin
About this chapter
Cite this chapter
Aspin, A. (2012). SQL Databases. In: SQL Server 2012 Data Integration Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4792-0_4
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4792-0_4
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4791-3
Online ISBN: 978-1-4302-4792-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books