SQL*Magic : Super*SQL
|SQL*MagicSuper*SQLCase StudiesResourcesTechnology ChoicesSQL StandardLinks

Top Ten reasons to try/buy Super*SQL

  1. Incredible value - Super*SQL provides you with a query tool that will work against almost any database on almost any hardware platform (Windows 95-XP, Mac OS 9.x, 10.x,Solaris, Linux and others). You get full text searching, data unload/load, batch support, and SQL dialect translation capabilities for only $US 9.95.

  2. No installation required - this is a 100% pure Java tool that will run from a CD, floppy disk (the jar file is only 172K) or a shared drive with no client-side installation.

  3. Move information between databases - The unload command generates an ASCII, delimited file which can be moved between database systems on different machines or between geographic locations. Encoding and translation of special characters such as embedded quotes means that there is no data lost.

  4. Web-based reports - with Super*SQL you can generate attractive and flexible reports that use Cascading Style Sheets to control the appearance of the output. This capability is independent of the version of any database you are using.

  5. Easy Summary/Subtotal reporting - Support for BREAK and COMPUTE commands allows you to easily create summary reports which compute subtotals and suppress duplicate column output.

  6. Dialect translation - if you are familiar with one SQL dialect (Oracle, SQL Server, MySQL, etc.) you can use that syntax when running queries against another database engine. Super*SQL will translate the query for you automatically.

  7. Command spooling and script files - Full support for spooling commands to a file and starting command files means that you can store complex queries for later use, regardless of whether or not your database system supports stored procedures.

  8. Support for batch processing - The ability to run all Super*SQL commands in true "batch" mode means that you can script database updates or generate reports on a scheduled basis using crontab or your preferred Windows scheduling tool.

  9. Convenience functions - functions such as Show Tables, Show Row Counts, and full text searching gives you useful information quickly and easily.

  10. Cross-database query capabilities - In the initial release of Super*SQL you can query from one database and store the results as a list in a "virtual" clipboard. You can then immediately connect to a different database and use the clipboard contents in a query. For example, if you had a list of company Social Club members stored in Excel or an Access database, you could store the employee names in the virtual clipboard. You could then connect to the company contact information database and retrieve information such as room number and telephone number for the members of the Social Club.

    The next major release of Super*SQL will include procedural language support which will allow almost unlimited cross-database querying. For example, it will be possible to create a report which combines information from a MySQL database running under Windows and a DB2 database running on an AS400.

So why not download Super*SQL and go through the tutorial, which takes only 20-40 minutes.