Configuring a MySQL linked server on SQL Server 2008
Linking servers provides an elegant solution when you are faced with running queries against databases on distributed servers or looking at your distributed assets...
MySQL Data Transfer using Sql Server Integration Services (SSIS)
There are a large number of posts on various difficulties experienced while transferring data from MySQL using Microsoft SQL Server Integration Services. While the...
Creating External Tables in your Oracle 10g/11g Database
In this two-part article by Hector R. Madrid, we will learn about the External Tables in Oracle 10g/11g Database. When working in data warehouse environments, the Extraction—Transformation—Loading (ETL) cycle...