Preparing tables for distribution is an important step in defining your Enterprise data movement model (EDMM). Preparing tables can be a very basic task, for example, if:
-
The table you are distributing has the same name at the sending and receiving servers.
-
You want to distribute all changed columns.
-
You want distribution to be continuous
-
A data enhancement method is not necessary
Preparing tables becomes more sophisticated as you add conditions to your EDMM, for example, if:
-
The table you are distributing has different names at the sending and receiving servers. See Send table and receive table have different names.
-
You want to distribute at a specific interval or on command. See Schedule data distribution.
-
You want to transform data as it is distributed from source to target.
-
The table is partitioned.
-
The target is a journal table.