Create a database table filter list


You can specify the -scope parameter of the stagingprop utility so that only data from selected tables is published to the production server. The -scope parameter accepts three predefined table sets - all tables, site data tables only, and merchant data only. You 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 creating your database table lists ensure that any referenced tables appear in the list before the referencing tables.

To create a database filter list:

  1. Create an XML file using 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 published to the production server to the tables in the list.

    table1, table2, tableX

    The database table names from which data is published.

    You can add additional lists by adding a new <TableList> tags within the <StagingConfig> tags. You can repeat table names in different lists. The same table name cannot appear more than once 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>
    
    
    

    You can also created multiple database filter files.

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


 

Related tasks


Listing server-managed tables

 

Related Reference


stagingprop utility