Create a database table filter list

We can specify the -scope parameter of the stagingprop utility so that only data from selected tables is published to the production environment. The -scope parameter accepts three predefined table sets - all tables, site data tables only, and merchant data only. We can also specify a custom list of database tables with the -scope and -configfile parameters.

The file specified by the -configfile parameter contains a list or multiple lists of database tables while the -scope parameter specifies which list or lists in the file to use.

The stagingprop utility follows the order of the database tables in the list or lists provided. When we are creating the database table lists, ensure that any referenced tables appear in the list before the referencing tables.

Procedure

1. Create an XML file that uses the following format:

   <?xml version="1.0" encoding="UTF-8"?>
   <StagingConfig>
   	<TableList name="list_name">
    	  <Table name="table1"/>
    	  <Table name="table2"/>
    	  ...
    	  <Table name="tableX"/>
   	</TableList>
   </StagingConfig>

   where:

   list_name

   The name of the list of database tables. Specify this name with the -scope parameter to limit the data that is published to the production environment to the tables in the list.

   table1, table2, tableX

   The database table names from which data is published.

   We can add more lists by adding a <TableList> tag within the <StagingConfig> tag. We can repeat table names in different lists. The same table name cannot appear more than one time in a list.

   The following file contains two lists:

   <?xml version="1.0" encoding="UTF-8"?>
   <StagingConfig>
   	<TableList name="list_name1">
    		<Table name="table1"/>
    		<Table name="table2"/>
     	...
    	  <Table name="tableX"/>
   	</TableList>
   	<TableList name="list_name2">
    	  <Table name="tableA"/>
    	  <Table name="tableB"/>
    	  ...
    	  <Table name="tableZ"/>
   	</TableList>
   </StagingConfig>

   We can also create multiple database filter files.

2. Save our changes and take note of the full path to the database filter list file.

Related tasks
List managed tables
Create a staging filter configuration XML file
Filter data for the stagingprop utility to propagate

Related reference
stagingprop utility