Filtering columns

At this point, you should see all of the columns for each of the tables selected previously listed with checkmarks beside them. By leaving all of the columns selected, you will be replicating all of the columns in the table. In some instances, you may want to replicate data, but certain columns are not to be replicated. A good example of this is a payroll table. Many systems can utilize the centralized data concerning personnel, but such things as salary should not be sent to these systems. In our example, we are only going to replicate the ID, last name, and first name from the authors table. To remove the rest of the columns from consideration, simply deselect them as shown in Figure 14-55.

Vertically partition the authors table

Replication Primer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40