In this example, the f_table1 table uses staging_db_two as its staging database. However, for the f_table2 table, a staging database name is not specified at the table level. Therefore, the table uses the target table database, MyDB, as the staging database. 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>MyDB</name> <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>