Pro ยท Lesson 4 of 11
Full load copies the current rows. It does not, by itself, keep copying the changes that happen while it runs.
Sign in to save your place.
Full load is emptying the shelves into the new shop once. If customers keep buying during the move, the new shop is already out of date unless you also run CDC.
The task reads tables from the source and writes them to the target. Table mappings decide which tables. The target tables may already exist, or the task can be allowed to create them. For a heterogeneous migration, creating tables from DMS type mapping is a rough start. A converted schema from the schema lesson is usually the better target.
Large object columns have their own mode: do not copy them, copy them in limited size, or copy them fully. Full LOB mode is slower. The right mode is a business question about whether those columns matter. There is no universal size.
DMS can split a large table into ranges when the engine and the table support it. A table with no key or no useful split column loads as one stream. Adding a key later does not rewind a finished load.
Indexes and foreign keys on the target slow the load. A common pattern is to load into a quiet target, then build secondary indexes, then turn on the constraints you still want. Do that from a written list, not from memory at cutover.
| Choice | Tradeoff |
|---|---|
| Full load only | Simple. Misses changes made during the load. |
| Full load and CDC | Copies current rows, then keeps going. Needs CDC prerequisites. |
| CDC only | Copies changes from a position. Does not backfill old rows. |
Step 1 of 3Full load reads the rows that exist when it reaches that table.
Step 2 of 3Mappings choose tables. LOB mode chooses how large values move.
Step 3 of 3The target holds a point-in-time copy, already aging if the source is busy.
Imagine the source takes orders during a six-hour load. Answer in a sentence.
Load window: 6 hours.
Orders created during those 6 hours are on the source only,
unless the task also runs CDC.
LOB columns we must keep:
LOB mode we will choose, and why:
Checked against the linked documentation in October 2026. A later release can move a flag, a price, or a supported pair. Use the page for the version you installed.