Restructuring tables and data (Transformation)
In various scenarios enterprise users might require the need to restructure tables and data while they are migrated, which is much more than just plain schema and data movement. Typical scenarios include: moving data from master database to reporting database applying transformation of schema and data for faster querying, migration from one version of the application to a newer version, migrating from one vendor based solution to another vendor solution etc., In all such scenarios you require the restructuring of both schema and data during migration.
SwisSQL Data Migration tool offers various options to achieve such transformations. Some of the features include: picking columns to be migrated, table and column name changes, datatype changes, column mapping in destination database, applying functions on data while migration etc., which makes SwisSQL suitable for this type of migrations.
Key Challenges:
- Options to transform schema as well as pick and choose schema attributes during migration
- Options to transform data during migration
- Options to map source database schema to destination database schema appropriately
- Ensuring seamless migration 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
- 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
- Restructure/Transform schema and data with ease during migration
- Migrates data across databases deployed on different platforms (Windows or Unix or Linux)
- Provides an uniform approach for migration across different databases
Demo:
