 |
| ||||
This tool is what you always wanted when you were thinking of working & Importing or Exporting Data: a dream come true ?
The main problem in the world of Data Manipulation-Transfers is STRUCTURES.
Indeed, normally it is easy to transfer data from one Table to another IF you know the structure of your Tables AND IF you have the possibility to implement these structures in your application.
This tool will let you Manipulate - Clone - Horizontalize all your Data without knowing any Source or Destination Table Structures. Data Management Center reads the data directly from the files themselves and lets you handle all the necessary mappings.
You will be able - for example - to open a client's Data Base and import all or part of their data in your application's Tables (different Structures - you just have to do your column mappings).
You will also be able to open a Table in ANY format and to CLONE it's structure to ANY SQL.
You will be able to open ANY source Table and decide to "Horizontalize" the Data to a specific Structure in ANY destination Format.
You will be able to use this tool to just open ANY table and Visualize it's content (also to export this data to many predefined formats (HTML - PDF - Word - CSV - XLS etc ... directly from the ListBox ).
Here are some key features of "Data Management Center":
· Supports migration & transfer of data across SQL Server, MySQL, Oracle, IBM DB2, SQL Anywhere, PostgreSQL, Pervasive SQL, Firebird , MS Access.
· Migration & Transfer of data from Excel, DBF, DAT, TPS and CSV (Comma Separated Value) files into databases.
· Migrates tables, indexes, constraints (depending on destination SQL) along with data .
· Supports advanced features for Data mapping during migration
· Criteria based data migration (data subsetting) is supported when migrating to any database.
· User can set the filter criteria for record(s) or column(s) based on which, only the rows matching the criteria (subset) will be migrated.
· If multiple criterias are set for a column, then the order in which they are defined will be used while migrating the data.
Limitations:
· The number of records you can insert is limited.
What's New in This Release: [ read full changelog ]
· Windows8 support (this OS is detected and buttons displayed in METRO style)
· Setting for SQL DateTime display in the format stored in the SQL server or Clarion way
· VIEWER limitations on ORACLE Tables using Cam elBackCasing (NO saving)
· DATA Transfer limitation (will not continue) when the DESTINATION Table is ORACLE using CamelBackCasing
· MULTI SELECTION (windows style) SQL or FLAT Tables and DELETE them directly with a rigth click
· When deleting or adding ODBC connections in the LEFT panel it will automaticaly refresh the RIGHT panel (if opened)
· New FUNCTION during data transfers : DEFORMAT() +
· VIEWER (export to CSV) - support to APPEND to an existing CSV file
· Support to Clone from ASCII to ... (single Table)
· Support to "remember last clone to folder for FLAT Tables"
· BUILD all Keys (internal tables) when you close the Project and Profiles module
· Left navigation panel (right-click) in MsSQL - MySQL and Postgre to CREATE a NEW DataBase
· Left n...
Via: Data Management Center 3.0.1 Build 1926
