Director of Software Development & Integration for Sta-home Health & Hospice, Inc.Chairman of the Board of Advisors for the Dynamics GP User Group (GPUG)
10+ years with Dynamics-GP (GL, AP, HR, Payroll, Maintenance, Training, Upgrades, Security) 15+ years as a Database Administrator (Maintenance, Performance, Warehousing, Validation, Correctness, Alerts, BI & Reporting)20+ years as a Developer (Written software for IBM, BCBS, Schools, Nursing Homes, & Home Health)
You can follow my blog here or my other networks below:
Any views contained within are my personal views and not necessarily Microsoft policy or the policy of Sta-home Health & Hospice, Inc.All posts are provided "AS IS" with no warranties, and confers no rights.
Blogs Outside of the Dynamics CommunityIn Recovery by Paul RandalSQL Skills by Kimberly Tripp
Post SeriesCreating an EDW for CBI SeriesGetting Data from Point A to Point B
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
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics