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.