This is the most common use when working with databases.
Step 1. Create a source database Connection.
Step 2. Create a destination database Connection.
Step 3. Start creating a Flow by selecting
Database to database in the Gallery.
Step 4. Add a new source to destination transformation.
Step 5. Define the transformation parameters when the source is a database.
Step 6. Define the transformation parameters when the destination is a database.
Step 7. Define the SQL action:
Step 8. If you want to extract only recently updated records, configure high watermark change replication. Please note that other types of change replication are available as well.
Learn how to move tables matching a wildcard name from one schema or database to another.
Please sign in to leave a comment.