K Database Magic

A utility that works as database desktop, SQL manager etc. for working with a range of databases.

This tool combines several common functions into one toolset that lets you work with a range of databases. The functions include database desktop, SQL manager, merging of data, data comparison and other functions. The program supports the databases including InterBase, Ms Access, Ms Excel, MySQL (ODBC), MS SQL, Oracle(ODBC), FoxPro, Paradox, dBase, and text data in CSV formats. The interface is quite intuitive and just about anybody should be able to get productive with it in short time. The interface is available in multiple languages. You could use it to edit, insert data to datasets. On top of that you would be able to save the changes to project files. Users could import and export data easily with the help of macros and functions. Comparing of two datasets for specific fields specified by the user is possible. Data management tools include data manipulation, creation, copy, print, import & export to other databases, etc.

The SQL manager can let you run multiple scripts executing to carry out SQL edit, collect history of executed scripts, processing, and monitoring. You would be able to set up multiple database connections as also view and edit data in tables. Program preferences are customizable. You will be able to set up directories, colors, fonts, icons, etc. Data export could be done in any one of four formats that include Excel, clipboard, CSV, XML files. Data dump or merging of data is available. Data table contents can be compared. All the datasets you work with can be printed along with selected field names. This is a very good product. If you are looking for a similar solution, you should try it in your exact workflow.

Database Desktop, SQL manager, merge data, data comparison and many more function in one software. It accomodate a simple admittance to datasets like other database handling products. Firstly it doesn't concentrate maintenance of datasets, but offer up users lot of built functions never a product before.
Shortly it's proud of the most important functions:
- Data manipulation between two datasets: Help user to import & export datas with macros and functions (merge datas).
- Compare two dataset by user specified unique fields.
- Multiple SQL Editors Script Executing (SQL Manager): SQL edit, history of executed scripts, processing, watching.
- Powerful data managing tools: data manipulation, create, copy, print, import & export other databases, etc.
- Now the program supported the following database types: Ms Access, Ms Excel, DB2, INFORMIX, INTERBASE 6, MSSQL, ORACLE, SQL Server, SYBASE, MySql(ODBC), Foxpro, Paradox, dBase, text driver(.csv)
And some other useful features:
- Searching datas by barcode scanner
- Viewing / Editing data in tables
- Multiple database connections
- Export data to four formats (Excel, clipboard, csv, xml files)