SwisSQL Data Migration solutions help enterprises overcome the challenge of managing data in multiple sources. SwisSQL offers a comprehensive solution to migrate data from one database to another database.
Moving to new database: Create database, tables and copy corresponding data from one database to another (even across heterogeneous databases)
Upgrading to new version of the database: Move schema and data from one version of the database/application to another (Eg., SQL Server 2000 to SQL Server 2005)
Filtering Data (data subsetting): Migrate/Copy data based on simple as well as complex criteria. If criteria is set for table(s), then its dependant tables will also be migrated based on its relationship
Restructuring tables and data (transformation): Migrate table and data applying wide range of restructuring/transformations options. Options include, table and column name changes, datatype mapping, selecting specific columns, column mappings etc., that can be applied during migration
