The following six-part series serves as an introduction to BIML by way of solving the problem of migrating data between two databases with the same schema.
BIML
Part 1 – Introduction
Part 2 – The Problem We’re Trying To Solve
Part 3 – The “Ideal” Package
Part 4 – Implementing The “Ideal” Package
Part 5 – Expanding To Multiple Tables
Part 6 – Lookups
In addition to this six-part series, we also covered a few side issues of interest:
Deleting Data In Batches
Generating An Empty Node
Tracing Foreign Key Dependencies
BIDS Helper Bug With NoMatch In Visual Studio 2013
IF Statements In Task Sections
One thought on “BIML”