DatAdmin

DatAdmin 2.2.3 is a graphical database interface that enables users to maintain and managing database structure and data. The application boasts of support for Microsoft SQL, Access, SQLite, MySQL, and Postgre SQL, in addition to linkage to any database with suitable drivers through ODBC/OLE DB. Further, it also supports creating and restoring back-up; transferring data within databases, files or tables; editing database schema; and various other tasks. Other functions offered by the utility include, running queries, viewing data, generating query templates, mastering/detailing view, editing database objects, etc. Along with these, it also includes a data browser with ‘Back’ and ‘Forward’ functions, and the capability of browsing database through the links defined by the foreign keys.

DatAdmin 2.2.3 has a neatly designed GUI divided in sections making it easy for the users to negotiate with its different functions. You can connect to the desired database and its structure, tables and data files, is displayed in tree-view form at the left pane. Explore the files and the data would be shown on the right side area on the screen. The Right window area consists of Summary and Data browser options to work with data and get the details relating to table or database file. Using the Data Browser you can browse the data, details, and also can use filter, paging and referenced data features. With the application it’s easy to edit or copy the data whether it’s a small or large sized table. Further, at bottom side of interface, it consists of three options; Data, Log and Processes. You can view the data in Text, Image, Binary data, and XML form, and also check out for its Properties. Along with these functions, the data can be exported or imported in tabular form to HTML, XML, SQL, or CSV files. Moreover, the program is also capable of generating SQL templates to work with SQL commands. These and many other features are available with the program.

DatAdmin 2.2.3 utility supports DBAs in performing various database related tasks, such as browsing, editing, copying, importing, exporting, etc. The tool is justifiably given 3.5 rating points, for the credible range of features, and praiseworthy functionality it displays while performing various supported tasks.

Graphical database interface, natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Also can be used to create and restoring backups, transfer data between databases, tables or files (supported formats are XML, CSV, HTML, SQL), edit database schema. Other functions: run queries, view data in tables of any size, generating query templates (create/update/delete), automatic master/detail view (based on foreign keys defined in database), editing database objects (view, triggers, stored procedures).