As I write my series on Creating an EDW for CBI I realized that I really needed to go into much more detail on getting data from Point A to Point B than that series allowed.
So in this series I will concertrate only on that one small aspect of the different ways of getting data from one table to another and some of the pros and cons of each. As you read the various examples please keep this post in mind
Also, unlike that series that goes from one post to the next. This series of post will start with this one as an Introduction and contain all the links to the various sub post. So, mark this page as it will be updated everytime I and a new method of getting data from one place to another.
1) Single Insert with Union Versus Multiple Inserts 2) Getting entire databases from one point to another