SQL Uniform SQL Uniform SQL Uniform - Query Comparison Export Convert Import Administration
SQL Uniform SQL Uniform

SQL Uniform
Indispensable development application to databases.

Home | Features | Changes | Supported databases | FAQ

Home
Screen shots
Download
Purchase
Login
Support
SQL Uniform

SQL Uniform is a database client, graphical user interface (GUI), a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert), import.

It supplies the databases with helper applications possessing a wide range of functions and several platforms accessibility. It allows graphical table design, running SQL statements, export, import 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.
This program is an ideal choice for administrators, programmers, web developers and also provides excellent information service for managers.
It supports any kind of database and database servers to which there is an ODBC or JDBC standard driver.
It has been tested on the following databases: Access, Adabas D, DaffodilDB, dBASE, Excel, HSQL, 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.
When starting the program for the first time, you can decide which mode of the program to be used. You can choose between freeware (Lite) and shareware (Professional) mode.

Advantages of applying SQL Uniform in practice
  • For managers:
    • You may learn how the purchases deviate from the original plan, the actual manufacturing from the pre-calculated one, the sales revenues from the business plan, the actual sales from the official sales price, the data of bookkeeping from the data of production.
      It may be used for overall controls, audits, exploring problems and weaknesses, you only need a reliable data service from any kind of data source.
      You can achieve money saving when using databases not provided with a graphical client, for example, in case of applying Microsoft MSDE you can save more than 500 EUR.
  • For database administrators and system operators:
    • A comfortable way of maintaining the customers' database regarding both data and structure.
  • For programmers and organizers:
    • Test purpose. You can determine what changes a program of any kind generates in the database according to the query – execution – repeated query with comparison method.

Main features
  • Comparison
    • Comparison of data in database tables, even between different types of databases.
    • Comparison of results of any SELECT statements.
  • Export (convert)
    • Saving of SQL queries' result data as text file, CSV or fixed length or HTML file.
    • Export of SQL queries' result data to any table of a different type of database.
  • SQL query
    • 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.
    • Semigraphic set of SQL statements (SELECT, INSERT, UPDATE, DELETE).
    • The result of SELECT statement can be updated on the spot.
    • Result can be filtered and ordered.
  • Design table
    • 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.
    • Supports every type of database at least on basic level by creating table and index, updating structure and dropping it.
  • Administration
    • Table design.
    • Quick selection.
    • Database, table, object and connection information.
  • Platform
    • The application may be equally used under Windows, Linux, Unix, Mac OS, OS2 and Solaris as well as all kinds of operation systems, where 1.4.1 version of Java runtime environment can be installed.
  • Connection
    • 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).
    • Connection to any kind of database through JDBC or ODBC standard drivers.
    • You can browse the data of several various types of database at the same time.



Site Meter