The Power of Multi-Table Auto-Migration
Rivery’s auto-migration feature streamlines data migration to the cloud by allowing for detection and mapping of multiple tables in the source database to tables in the destination cloud data warehouse through both standard and real-time (Change Data Capture) data synchronization protocols. This new feature allows for additional user control over individual target table mapping/naming.
How to set custom target table names in multi-table migrations (step-by-step)
-
Click on the “Rivers” tab in the main menu.
-
Select your data source to target river that conducts your data migration.
-
Navigate to the “Source” tab, scroll down and ensure that “Multi-Tables” is selected as the River mode.
-
Navigate to the “Mapping” tab.
-
Check the next to the schema that contains the tables that you want to load.
-
Select the next to the tables that you want to load.
-
Select the under “Table Name” next to the table that you selected and enter the desired table name in the prompt that follows and hit “OK”.
-
Repeat steps 5 - 7 for any other tables that you desire to rename for loading into the destination cloud data warehouse.