You can exclude a table when replacing a database by specifying its name. Excluding a table that exists on the target does not remove the existing target table.
- Set <replaceDatabase="true"> to replace the specified database.
- Set <table selection="excluded"> and then specify the table name.
In the following example the target database is replaced with the source database but the Customers table is not copied to the target.
If the Customers table already exists on the target, excluding it in the XML as shown below does not remove it from the target.
<database selection="included" replaceDatabase="true"> <name>MyDatabase</name> <table selection="excluded"> <name>Customers</name> </table> </database>