ISP

International
Software Products

Home  |   Products  |   Support  |   FTP Site  |   Offices  |   Partners  |   Contact Us

 

 


DARSWIN

CA-IDMS Schema Analysis and Conversion Plus Space Report Analysis for RDBMS Size Estimation

 

Features

 

Schema Analysis:

 

»

Full Windows 95/98/Me/XP Pro/2000 Pro and Server/2003 Server GUI Interface

 

»

Identification of CA-IDMS® constructs not easily supported in RDBMS

 

»

SET replication parameters

 

»

Record Selection for Replication

 

»

Element Selection for Replication within Record

 

»

Optional Date, Time and Journal Sequence Number columns for target TABLEs

 

»

Complete Target DDL - CA-IDMS SQL, DB2/UDB, Informix, MS SQL Server, Oracle and Sybase

 

»

Utility function to generate the DARSTRAN® Initial Load extract control statements

 

 

 

 

 

Space Report Analysis:

 

»

Calculates Total Row Lengths per Target TABLE

 

»

Identifies SET Eligability for Foreign Key Relationships in the Target TABLEs

 

»

Calculates the Number and Length of Each Foreign Key

 

»

Calculates Total Data Space per Target TABLE

 

»

Calculates Total Index Space per Target TABLE

 

»

Calculates Total Size in Bytes and Megabytes of the Target Database

 

»

Calculates Total Number of Record Occurences in the CA-IDMS®Schema

 

»

Provides Estimates of the Transfer Time to Move the Initial Load Data to the Target Platform

 

 

 

 

 

Schema Translation Features:

 

»

User Specified Column Names if the default is not sufficent

 

»

User Defined Columns for the Target RDBMS

 

»

Schema Merge Facility

 

»

SelecTABLE Target RDBMS

 

»

Separate TABLEs for OCCURS DEPENDING ON Groups

 

»

Single Target TABLE for multiple similar CA-IDMS Records

 

»

Date Element Masks for auto date element conversion


All Trademarks Acknowledged

Copyright 2009 International Software Products. All Rights Reserved.