메인으로

Migration Center supports integrating with various third-party databases.Since the JDBC driver is used to connect to the database, it is important to prepare the appropriate JDBC driver for the source database and the target database.Supported Databases for Migration CenterSource Database Target Database Altibase: version 4.3.9 or laterOracle Database: 9i - 11gMicrosoft SQL Server: 2005 - 2012Oracle MySQL: 5.0 - 5.5Informix: 11.50Oracle TimesTen: 7.0, 11.2CUBRID: 8.4.1 - 9.3.5 (ISO-8859-1, UTF-8 charset)Tibero: 4sp1~6 Altibase: Altibase version 5.5.1 or later 

Due to the high maintenance cost and unstable technical support, the number of customers who want to convert their existing DBMSs to Altibase is increasing.Altibase provides its migration service to help customers convert their existing database to Altibase. With our experience and methods, we analyze customers’ databases and suggest improvement plans to help them safely migrate to Altibase.Migration service is a paid consulting service. For more detailed information and explanation, please contact us: us@altibase.com or +82-2-2082-0435.Key FeaturesData modeling and composition, resource estimation, optimal data architecture consulting serviceTuning to improve performance, diagnosing and identifying performance issuesGuideline support for DBA operations and developersEnvironment analysis and configuration for efficient replication operationMigration risk analysis and planningDatabase monitoring, backup, and disaster recovery strategiesKey BenefitsIncrease efficiency with a single-window for DBMS maintenance operationProvide a regular preventive inspection system by professional engineers and shorten the initial response time in case of failureProvide professional consulting services other than disability preventionReduce costs for processional and consulting operations

The migration process takes approximately one day per TB of data. If your system can handle concurrent processing, approximately 4TB of data can be migrated per day. If you have a significant amount of data (petabytes), parallelization can be utilized to expedite the migration.Migration ProcessPhaseActivitiesDurationSystem AnalysisAnalysis of source DBMSconducting interviews with DBAsPreparing analysis reports1 day per DBMSImpact AnalysisAnalysis of change impact of applicationPreparing report for the degree of impact1 day per DBMSPlanningSchedulingPreparing resources plan1.5 dayMigrationData MappingDefining data mapping rules+ α(depends on schema complexity level)ExecutingVia Migration Center1 day per terabyteOptimizationPerformance tuning and testing1 ~ 3 daysTotal5 days + α(α: day(s) affected by application change impact) Examples of Migration Results Company ACompany BSource DBMSOracle 9iInformix 11.50Number of Tables2,000800Number of Indices7,0002,000Data Size350 gigabytes2,048 gigabytesTotal Duration4 days(10 hours for data migration)5 days(48 hours for data migration)

Negligible. It is simple to update applications for use with Altibase because Altibase provides standard database interfaces that use the common syntax as defined in SQL:1999. Upon completion, you will experience the extreme performance, flexibility, data integrity, low latency, and high throughput.An Example of Successful Migration Project NameDBMS upgrade for the payment gateway systemRequirementsDatabase migration without shutting down the systemHA architecture upgrade from active-standby to active-activeData integrityResultsSuccessful database migration without system shutdownSuccessful implementation of the active-active architecture100% data integrityAltibase’s Impact ItemsBusiness FunctionTechnologyInterfacePerformanceROITCOTime to ValueDegreeEnhancedEnhancedUnchangedExtremeSwiftLowShort

Yes. Altibase guarantees data consistency with proven methodology and extensive battle-tested experiences. Altibase’s Migration Center executes a validity check to ensure that the data in the source database and the data that were migrated to the target database are identical. In addition, if there are any inconsistencies, Migration Center will generate a report so that the user can intervene.Data ConsistencyAltibase Migration Center meets the requirements to guarantee data consistency via:Analysis phase: validation of execution rules through accurate analysis of duplicated data, mismatched data types, etc.Migration phase: comparison of data values between source and target data objects An example of a comparison report:Time InformationDurationStart TimeEnd Time0:00:00.51609/04/2013 16:05:1109/04/2013 16:05:11Database InformationSource DatabaseTarget DatabaseConnection Nameora11gAltibaseAddress192.168.1.62:1521127.0.0.1:20300DB NameOracleALTIDBUser IDOrauserAltiuserMigration InformationObject# of Differences# of Source Objects# of Target ObjectsSequence01010Table 10100100Row0100,000100,000Data Value0400,000400,000Table 20100100Row0100,000100,000Data Value0400,000400,000Table n0100100Row0100,000100,000Data Value0400,000400,000Constraints055Index03030Synonym033

Altibase offers an automation tool: Migration Center. It migrates various kinds of data objects from sources to target databases and ensures 100% data integrity and consistency.Migration CenterMigration Center is a database migration tool that copies compatible database objects and data from other databases to Altibase. Manual tasks of database migration are complicated, time-consuming and prone to human error. Migration Center helps users to process database migration with a few mouse clicks in the Graphic User Interface (GUI) mode. It also supports the execution of migration using a Command Line Interface (CLI) mode.Internal Process of Migration CenterDefine database source and target:Source and target database IP addresses and portsSource and target user ID, password, JDBC driver, character set encoding, etc. Define data objects to migrate:Source and target data objects information: table, column, index, view, procedure, etc.Define migration options:Selection of options: Thread count, batch size, etc.Selection of migration scope: User mode and table modeData type mappingTablespace mappingStored procedure convertingDDL ModificationValidate migration rules Execute migration via rules Review the report files RunReport4Summary.html: the summary report file that provides the overall result of migrationRunReport4Missing.html: the report file that provides the list of data objects which were not migrated properlyDbObj_Failed.sql: the list of failed SQL commands and the cause of each failureMigration Center AdvantagesEasy and simple migration from other DBMSs to AltibaseFlexible mapping of different types of data objectsMigration summary report to review the migration resultHigh performance parallel migrationManual rule modificationMigration Center SpecificationsSource DatabasesAltibase 4.3.9 or higher versionsOracle 9i or higher versionsTimesten 7.0, TimesTen 11.2SQL Server 2005 ~ 2012MySQL 5.0 ~ 5.5Informix 11.50CUBRID: 8.4.1~9.3.5(ISO-8859-1, UTF-8 charset)Target DatabaseAltibase 5.5.1 or higher versionsGUI ToolJRE : Sun or IBM Java 5 or higherProcessor: 800MHz Pentium III or betterMemory: 512MB or moreDisk: 150MB or more free spaceScreen resolution: 1024 x 768 pixels or greaterOS graphic libraryCLI ToolJRE : Sun or IBM Java 5 or higherProcessor: 1 CPU or moreMemory: 512MB or moreDisk: 150MB or more free space