Main > Utilities > System Maintenance and Repair >

DatAdmin Personal 3.0.1



 

DatAdmin Personal 3.0.1

Sponsored Links

DatAdmin Personal 3.0.1 Ranking & Summary

RankingClick at the star to rank
Ranking Level
Buy now
User Review: 0 (0 times)
File size: 3.34 MB
Platform: Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows
License: Freeware
Price: $0
Downloads: 20
Date added: 2009-05-09
Publisher: JenaSoft

DatAdmin Personal 3.0.1 description

DatAdmin Personal 3.0.1 is a useful tool which offers you easy and quick database administration and natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. It can also be used to create and restoring backups, transfer data between databases, tables or files (supported formats are XML, CSV, HTML, Excel), edit database schema. This edition is free for non-commercial use and has no limits, no basic functionality restrictions. It is absolutely suitable for students and for developers non-commercial web pages working with databases

Major Features:

  1. Connect to database
    • Connect using ADO.NET native drivers. Distributed with native ADO.NET drivers for MySQL, PostgreSQL, Sqlite. 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
  2. Database management
    • Creating and editing tables (CREATE, ALTER TABLE), database specific table properties (MySQL engine, collation)
    • Luxurious 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
    • Table of supported database objects for each database platform
  3. 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
  4. Backup, export, import
    • Backup database as "Data archive" - ZIP file - platform and database independent backup
    • Ability to use native backuping 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
    • 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)
  5. 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
  6. SQL Editor
    • SQL Editor with syntax highlighting
    • Advanced search & replace
    • Savin gSQL query to connection - locally or in database
    • Viewing more resultsets from one query
    • Graphical query designer, with drag & dropping tables from connection tree, tables could be joined (LEFT/RIGHT/INNER/OUTER JOIN), sorting, filtering, grouping
WareSeeker Editor

DatAdmin Personal 3.0.1 Screenshot

DatAdmin Personal 3.0.1 Keywords

Bookmark DatAdmin Personal 3.0.1

Hyperlink code:
Link for forum:

DatAdmin Personal 3.0.1 Copyright

WareSeeker.com do not provide cracks, serial numbers etc for DatAdmin Personal 3.0.1. Any sharing links from rapidshare.com, yousendit.com or megaupload.com are also prohibited.

Allok Video Splitter 2.2.0 Review:

Name (Required)
Email(Required)
Captcha
Featured Software

Want to place your software product here?
Please contact us for consideration.

Contact WareSeeker.com
Related Software
Database manager for MySQL, MS SQL, SQLite with many functions (backuping...) Free Download
A simple tool to export, import, migrate and convert data and text CSV files. Free Download
Database navigation tool Free Download
Import, Validation, De-Duplication and Transformation of Data Free Download
Data Tier Creator - The Code Generator, O/R Mapper and RAD Tool for .Net Free Download
MDB Exporter export data from MDB database files to CSV files Free Download
File Data Viewer - enable the user to maintain a database Free Download
LBE Helpdesk Data Migration Tool - migrate LBE Helpdesk data from an Access database to Oracle or Sql Server Free Download