DatAdmin Professional

This is a software that has tools for efficient administration of databases.

This is a tool that can provide harassed DBAs relief in the form of quick and easy database administration. The software supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access, EffiProz databases natively. One of the first and foremost features you need in databases is the backup and the restore functions so that your assets are always safe. The design focuses on easy usage. This tool works well with so many databases yet feels like native tools specifically designed for one particular database. A job scheduler lets you schedule tasks that can include transfer of data between databases, tables, files etc. While transferring, you could use XML, CSV, HTML, Excel formats. Other such tasks can be FTP of the data. The program also has a command line interface to make running a script quite easy.

Data in the tables can be manipulated through the edit, view, filter and sort capabilities, referenced tables and master detail views can be generated of the data in tables. For a complete understanding of the database it is possible to edit the schema, tables, views, triggers and stored procedures, database diagrams in customizable styles are available. Synchronization of databases is possible through the program. SQL script editor let you generate queries, edit them, building history are useful query related features. Harassed DBAs of the enterprises could easily use these tools to ease their lives largely. To help them in this quest the interface offered is also quite easy to use.

Quick and easy database administration, natively supports Oracle, MSSQL, MySQL, SQLite, Postgre SQL, MS Access, EffiProz.
Main features:
Creating and restoring backups.
Transfer data between databases, tables and data files (supported formats are XML, CSV, HTML, Excel).
Open exported data in external application, save to FTP.
Saving data transfer jobs, jobs scheduler.
Edit database schema, tables, views, view, triggers, stored procedures.
View, edit, filter and sort data in tables.
Display data from referenced tables, master-detail views.
Command-line interface.
Database modeling, reverse engineering.
Database diagrams, customizable graphical styles.
Migrate database between all supported platforms.
Advanced SQL editor, syntax highlighting, code completion, SQL script manager.
Database structure synchronization.
Flexible generating SQL from tables, views and from data
Query builder, query history.
Database object dependency browser.
Reusable table perspectives, view related columns in data browser.
Configurable dashboards, widget designer.
Visualise result sets in charts.