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:
KeywordsMigration Drilling Editing
Unable to display preview. Download preview PDF.
© Adam Aspin 2012