Database Administration Tools
Database Administration
Database administration is the process of establishing computerised databases, and insuring their recoverability, integrity, security, availability, reliability, and performance.
From: en.wikipedia.org/wiki/Database_administration
DataBrowser
The DataBrowser is a Java based
cross-database, cross-platform
data access tool. It is stable, feature rich, and mature (initially
released in 1999). As of June 2004 it has over 16,000 users
worldwide.
It's core features include:
- 100% Java, compatable with Java 2 versions 1.3 and 1.4.
- Connectivity
- Connect to ANY database with a JDBC driver
- Connectors included for ODBC, Oracle, DB2, PostgreSQL,
MS SQL Server, MySQL, InstantDB,
- Generic connector will work with literally any driver
- Maintains a list of recent connections, so you don�½t
have to constantly re-type connection information.
- Browsing
- Browse a database�½s tables and view schemas in an intuitive
treeview
- Limit your browsing to a particular catalog, schema, or type
- Right click to view typical data in a given table
- Open multiple browser windows connected to various different
databases. You can browse Oracle, Access, SQLServer and DB2
all at the same time.
- Editing
- Syntax-highlighting sql editor.
- Add data to tables with a GUI interface.
- Update data in tables.
- Dynamic SQL Support
- Execute any SQL statement
- Save complex SQL with a "SQL Bookmark" for later use.
- Easy to use interface allows less technical users to browse
enterprise databases. MUCH easier to use than SQL Plus, DB Access.
Much more lightweight than MS Access.
- Use in the course of software development to develop queries, then
simply copy and paste your query right into your code!
Loading .....