DatAdmin Personal 2.3.3

DatAdmin Personal 2.3.3 is a versatile and convenient product. DatAdmin is easy-to-use grafical database interface for Windows XP/2000/Vista. It also can be used to create and restore backups, transfer data between databases, tables or files (supported formats are XML, CSV), edit database schema.

You can use it to maintain database structure or manage database data. Now it natively supports Microsoft SQL, MySQL, SQLite, Postgre SQL and Access. Also there is possibility to connect via ODBC or OLE DB to any other database with appropriate drivers. DatAdmin is freeware for non-commercial use. nd Edition; Windows ME; Windows Server 2003; Windows XP Service Pack 2, Windows Vista 

Major Functions:

1. SQL command execution, browsing results in grid
2. Visual database management, displaying database structure in tree, modifying table structure
3. Visual editing of table structure, including defining primary and foreign keys, indexes, CHECK and UNIQUE constraints.
4. Editing data in tables of any size
5. Native access to MySQL, SQLite, MS SQL Server, MS Access and Postgre SQL, support for all data types
6. Export and import tabular data from/to CSV, XML
7. Drag & Drop operations with tables and databases, copying tables and databases also between different databases
8. Generating SQL templates for create, update delete SQL commands
9. PHP tunnel function allows user connection to database accessible only ofrom PHP scripts
10. Database design, which is independend on target database.
11. Showing lookup fields in data grid
12. Long-running operations (queries, data loading, prcoesses - backuping, exporting table data) can be canceled
13. Managing of view, triggers, stored procedures and functions
14. Export and import data to/from Data Archive, which is database backup independend on database platform

Major Features: 

1. Supported databases:  MySQL, Microsoft SQL Server, SQLite, MySQL over PHP tunnel, MS Access, Postgre SQL, Generic database connection  

  2. Table definition editor    

• Defining columns  
• Defining primary keys  
• Defining foreign keys  

3. Table data editor    

• Editing data  
• View cell as image  
• View cell as XML  
• Editing cell data in window  
• View reference lookups    
• View reference selection  

• Export database to data archive  
• View structure of data archive in tree  
• Import from data archive  
• Import selected tables from data archive  

  5. Export/import table data    

• Export to CSV  
• Import from CSV  
• Export to ADO.NET XML  
• Import from ADO.NET XML  
  

  6. Addon support  

• Custom popup-menu commands
• generating or running parametrized SQL
• Node generators
• Way to show database data in tree  
• Object views
• Shows table data, when clicking on tree item  
• Data stores
• saved configuration of table output

Requirements:

1. Microsoft .NET framework 2.0
   
2.  Windows 2000 Service Pack 3; Windows 98; Windows 98 Seco