SQL Uniform Lite
|
SQL Uniform Lite is the freeware from SQL Uniform, it is a general interface--a helper software to relational databases of various types regarding query, maintenance, data comparison and export. It supplies the databases with a suitable graphical user interface (GUI), helper applications possessing a wide range of functions and several platforms accessibility. It allows graphical table design, running SQL statements, export and comparison of data in a heterogeneous environment and offers many other useful services that help you to perform your daily tasks more quickly and efficiently.
Main features
Comparison
1. Comparison of data in database tables, even between different types of databases.
2. Comparison of results of any SELECT statements.
Export (convert)
1. Saving of SQL queries' result data as text file, CSV or fixed length or HTML file.
2. Export of SQL queries' result data to any table of a different type of database.
SQL query
1. Optimized memory management. The memory will not be fulfilled even in case of queries containing millions of rows, because SQL Uniform stores the results in quickly accessible temporary files.
2. Semigraphic set of SQL statements (SELECT, INSERT, UPDATE, DELETE).
3. The result of SELECT statement can be updated on the spot.
4. Result can be filtered and ordered.
Design table
1. Implementation worked out differently depending on the type of database. Basic level work out allows table and index maintenance, that of advanced level may contain check, trigger, view, primary key, foreign key, constraint, stored procedure management as well.
2. Supports every type of database at least on basic level by creating table and index, updating structure and dropping it.
Administration
1. Table design.
2. Quick selection.
3. Database, table, object and connection information.
Platform
* The software may be equally used under Windows, Linux, Unix, Mac OS, OS2 and Solaris as well as all kinds of operation systems, where 1.6 version of Java runtime environment can be installed.
Connection
1. Help on connection for more than 20 sorts of database (Access, Adabas D, DaffodilDB, dBASE, Excel, HSQLDB, IBM Cloudscape, IBM DB2, Interbase (Firebird), InterSystems Cach , JDataStore, Linter (Relex), McKOI, Mimer, MSSQL, MySQL, Openlink Virtuoso, Oracle, Paradox, Pervasive (Btrive), Pointbase, PostgreSQL, Quadcap QED, Solid, SQLITE, StelsCSV, Sybase, ThinkSQL, Yard).
2. Connection to any kind of database through JDBC or ODBC standard drivers.
3. You can browse the data of several various types of database at the same time.
The license of this software is Freeware, you can free download and free use this database management software.

