You can exclude one or more tables from being copied from the source to the target when you copy an entire database using ARC.
- Open the parameters.xml file that has the job definition information for the job.
- Under the database name, add the selection="excluded" attribute to the table element.
- Add a <name> element and enter the name of the table to be excluded.
In the following example, all tables except DBName.Orders and DBName.Accounts are copied to the target.
<database selection="included"> <name>DBName</name> <table selection="excluded"> <name>Orders</name> </table> <table selection="excluded"> <name>Accounts</name> </table> </database>