SwisSQL - Data Migration Tool 5.6 Description:

AdventNet SwisSQL offers a complete Data Migration utility that will help the migration of database structures and data across leading databases such as Oracle, IBM DB2, MS-SQL Server, Sybase, SAP DB, and MySQL.

It offers an open, user-friendly, and extensible migration process ensuring reliability and data integrity.

SwisSQL - Data Migration Tool 5.6 Features:

· Supports migration/transfer of schema and data across Oracle, IBM DB2, SQL Server, Sybase, MySQL MaxDB, MySQL, PostgreSQL and MS Access databases
· Migration of data from Excel and CSV (Comma Seperated Value) files into databases
· Supports connection to Databases using JDBC drivers. Tool bundles default drivers for easy connectivity
· Supports connection to SQL Server through Windows Authentication
· Migrates Tables, Indexes, Views, Constraints along with data.
· Maintains the relationship between the tables as in the source database. Identifies dependencies between master and child tables and also orders the tables with primary key and foreign key.
· Migrates data from Excel and CSV (Comma Separated Value) files into databases.
· Support for migration and transformation of data using SQL SELECT queries.
· Supports migrating stored procedures, functions, triggers if the source and target RDBMS are the same. Following migration combinations are supported currently: SQL Server to SQL Server, Oracle to Oracle, DB2 to DB2 and Sybase to Sybase.
· Criteria based data migration (data subsetting) is supported when migrating from Oracle, SQL Server, MySQL and Sybase ASE to any database. User can set the filter criteria for a 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 will also be migrated based on its relationship.
· Handles the migration of auto increment columns appropriately
· User defined DB2 Schema objects can be migrated to any database
· Oracle spatial database can be migrated to DB2 spatial database
· Provides option to save the generated target CREATE statements(DDL) in a file
· Provides option to delete existing objects before the new objects are are migrated from the source database
· Provides option to migrate both schema and data, or just data, or just schema alone
· Back's-up tables in target database before migration
· Option to choose only the necessary columns to be migrated in a table
· Option to change the table and column names in the target database during migration
· Option to map columns in source database to appropriate columns in destination database
· Option to change the datatype of columns in a table and or across all the tables
· Option to migrate and transform data using SQL SELECT queries.
· Option to join together data from multiple source tables and migrate to target database . Supports one-to-many, many-to-one and many-to-many mapping of source and target tables using SQL SELECT queries.
· Option to modify / translate the data such as generating a new calculated value from existing data using SQL SELECT queries.
· Provides simple, easy to use, wizard driven GUI for migration
· Configurable options to choose the migration of tables, indexes, views, and data.
· Provides detailed and summary migration reports.
· The integrity of the data (along with the database objects) migrated can be verified using a unique tool named "Database Migration Verifier". Currently verification is supported only for SQL Server to Oracle migration
· Supports Project driven approach for organizing the migrations for better management.
· Summary view highlighting the migration
· Third party JDBC drivers can also be loaded for database connectivity
· Feedback option is provided in all the screens to report feedback/issues instantly.

SwisSQL - Data Migration Tool 5.6 Requirements:

· 128 MB RAM.
· PIII 800 MHz.
· 50 MB hard disk space.

SwisSQL - Data Migration Tool 5.6 Limitations:

· 10 tables and their constraints (Primary key, unique key, not null, and check constraints)
· 5000 rows per each table
· 10 indexes
· 10 stored procedures and functions
· 10 triggers
· 30 days trial

Related:

data recovery - advanced data export

Related searches:

gps data tool

SwisSQL - Data Migration Tool security information

You cannot download any crack or serial number for SwisSQL - Data Migration Tool on this page. Every software that you are able to download on our site is legal. There is no crack, serial number, hack or activation key for SwisSQL - Data Migration Tool present here. Our collection also doesn't contain any keygens, because keygen programs are being used in illegal ways which we do not support. All software that you can find here is freely downloadable and legal.

SwisSQL - Data Migration Tool installation package is prepared to be downloaded from our fast download servers. It is checked for possible viruses and is proven to be 100% clean and safe. Various leading antiviruses have been used to test SwisSQL - Data Migration Tool, if it contains any viruses. No infections have been found and downloading SwisSQL - Data Migration Tool is completelly problem free because of that reason. Our experts on malware detection tested SwisSQL - Data Migration Tool with various spyware and malware detection programs, including fyxm.net custom malware and spyware detection, and absolutelly no malware or spyware was found in SwisSQL - Data Migration Tool.

All software that you can find on our servers, including SwisSQL - Data Migration Tool, is either freeware, shareware or open-source, some of the software packages are demo, trial or patch versions and if possible (public domain licence), we also host official full versions of software.

Because we want to be one of the fastest download sites on the web, we host all the software including SwisSQL - Data Migration Tool on our servers. You cannot find here any torrents or download links that would lead you to dangerous sites.

Fyxm.net does support free software, however we do not support warez or illegal downloads. Warez is harming producers of the software.

Enjoy!