In this example, the f_table1 table uses the staging_db_two database. The staging_db_one database specified at the database level is overridden. The f_table2 table uses the staging_db_one database that is specified at the database level. Data Mover supports using either the staging_database or target_staging_database tags to specify the target staging database, but not both at the same time.
<database selection="unselected"> <name>DBName</name> <staging_database> <name>staging_db_one</name> </staging_database> <table selection="included"> <name>f_table1</name> <staging_database> <name>staging_db_two</name> </staging_database> </table> <table selection="included"> <name>f_table2</name> </table> </database>