In enterprises its very common need to pull out a subset of data from a master database for various purposes. Some of needs include: setting up a test database with valid data subset, have a separate dataset for reporting, moving relevant data to various departmental databases from the master etc., You need a solution that could pull out a valid subset of records from the database based on certain filtering criteria.
SwisSQL offers a simple yet powerful option to specify criteria during migration based on which subset of data could be moved from one database to another. User can set the filter criteria for table(s) based on which, only the rows matching the criteria (subset) will be migrated. If criteria is set for a table, then its dependant tables (identified through primary-foreign key relationship) will also be migrated based on its relationship automatically. This way SwisSQL ensures only the creation of a valid data subset always
Key Challenges:
- Option to specify the Filtering Criteria
- Ensuring a valid data subset is created, taking into consideration data in dependent/related tables
- Avoiding any loss of data during migration
- Migrating the data swiftly
SwisSQL Solution:
- Use the Data Migration tool to select the source and target database by providing the connection details
- Choose the necessary tables to be migrated
- Specify the Filtering Criteria
- Configure required data type mappings and other migration options
- Migrate Data and Verify status using migration report.
Execute all steps described above through a well directed and straight forward wizard
Key benefits include:
- Easy to Install and Easy to Use tool with user friendly & intuitive GUI
- Rapid data migration across databases ensuring data integrity with no loss of data
- Migrates data across databases deployed on different platforms (Windows or Unix or Linux)
- Provides an uniform approach for migration across different databases
Demo:
