Administer > Stage server > Staging server utilities > stagingprop

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.

Procedure

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 the changes and take note of the full path to the database filter list file.

Related tasks

List server-managed tables

Related reference

stagingprop utility

+

Search Tips   |   Advanced Search