Software Software
JenaSoft DatAdmin Ultimate v4.4.6
Date: 6 January 2011 | Author: YOMATA | Views: 108    

JenaSoft DatAdmin Ultimate v4.4.6 Free & Full Download


JenaSoft DatAdmin Ultimate v4.4.6 | 6.5 Mb

DatAdmin is a database administration tool that allows working with MySQL, MS SQL, SQLite, PostgreSQL, EffiProz and MS Access databases. Its design is primarily focused on easy usage and thanks to the modularity and flexibility of the tool, it can be from functionality standpoint compared to single-database focused programs.

Connect to database
  • Connect using ADO.NET native drivers. Distributed with native ADO.NET drivers for MySQL, PostgreSQL, SQLite, EffiProz.
  • Native drivers for MS SQL are distributed with .NET.
  • Function Driver manager, which allows using other ADO.NET drivers
  • Connection over generic database interfaces OLE DB and ODBC
  • Function PHP tunnel, which allows connection to MySQL databaases on webhosts server, which dosn't offer direct access to database server
  • Creating new file base databases (SQLite, Access, EffiProz)

Database management
  • Creating and editing tables (CREATE, ALTER TABLE), database specific table properties (MySQL engine, collation)
  • Comfortable foreign key management, UPDATE/DELETE rules
  • CHECK, UNIQUE constraints, indexes
  • Database object management - triggers, functions, stored procedures, views, schemata
  • Generating SQL scripts for different object types - CREATE, DROP
  • MySQL objects: triggers, functions, stored procedures, views, events
  • MS SQL objects: triggers, functions, stored procedures, views
  • SQLite objects: triggers, views
  • Table of supported database objects for each database platform

View and edit data
  • Viewing and editing data in table
  • Quick fulltext search
  • Filtering rows - fulltext search or SQL conditions
  • Sorting rows by clicking on column header, sorting by more columns
  • Lookups (preview of destination foreign key row), selecting rows from validation tables
  • Automatic master/detail views created from foreign keys
  • Forward/Back function for browsing master/detail views history

Backup, export, import
  • Backup database as "Data archive" - ZIP file - platform and database independent backup
  • Ability to use native backup tools (mysqldump, pg_dump)
  • Restore from backup, restore whole database or selected tables (selecting tables is possible only when using data archive as backup format)
  • Export of table data to formats CSV, TXT, HTML, XML, SQL, Excel
  • Import of table from formats CSV, XML
  • Export database structure into formats HTML, WIKI
  • Copy database/table to another server using drag & drop
  • Transform table data when copying or exporting table. Columns can be reordered, column value can be fixed or transformated using Python.
  • Transformation can be saved and later reused.
  • Any data operation can be saved as job and executed later, also from command line
  • Scheduling using Windows Scheduler Service (applicable to any type of job)

Database design
  • Editing of database model. Model can be generic or database specific
  • Definition of tables, keys, constraints
  • Definition of all object types in database model
  • Database diagrams, stored in connection (locally or in database)
  • Comparing & synchronize structure of model, real database or data archive (database backup)
  • Migration of model to different dialect
  • Generating CREATE/DROP scripts in any of supported dialect
  • Reverse engineering - loading model from existing database

Query designer
  • Drag & drop tables and joins
  • Support for left, right, inner and outer join
  • Quick adding referenced table (only by clicking on referencing column)
  • Condition builder with handy conditions not directly supported by SQL (column contains text?, column contains one of string?). You can build complex
  • conditions with AND and OR operators in the some as trivial conditions
  • Saving and loading designed scripts, generating SQL from designed query

Query editor
  • SQL Editor with syntax highlighting
  • Advanced search & replace
  • Scripts folder - you don't have to thing about where you have your scripts
  • Saving query context with query (server, database)
  • Viewing more resultsets from one query
  • Query variables, if you use it, you are asked before every query execute
  • History of executed queries

Download

Share This Post :


Related Posts
Please Login or Create a FREE Account to Post Comments



Information

Members of Guest cannot leave comments.