Radem-Soft

Home      Features      Download      Register      Contact us      Links     

Welcome to Radem-Soft ! RapidQuery is an easy to use, fast and cross-database powerful query tool. RapidQury is packed full of features. With RapidQuery you can run any script or sql statement, export query results to HTML,XML,CSV,EXCEL, table in any database, load data, migrate all database and much more. RapidQuery supports the following databases: DB2, Firebird, Informix, Interbase, MySQL ,ODBC, OLEDB, Oracle, PostgreSQL, SQLBase, SQLServer, Sybase. To be specific DB2 is DB2 for mainframe (ZOS,MVS), Windows, Linux, Aix and Unix.

Radem-Soft specializes in the design, development and deployment of desktop tailored applications. Being in business for over two decades Radem-Soft's team of professionals is at the forefront of providing software customized solutions for its satisfied clientele. Please feel free to contact us with any comments or requests. When deciding on the database layer of an application the benefits and drawbacks of different types of relational databases are taken into consideration. It raises the need for a cross-database query tool that can support the leading databases in the market. Wouldn't it be self serving to have a powerful query tool that supports multiple databases and consolidates querying into one single tool? RapidQuery does exactly that. The target audience is programmers and professional staff who have basic knowledge of Sql Language. The price of RapidQuery is $USD 125 which Radem-Soft believes is a reasonable price for the quality and the Features of the product. Version 2 of RapidQuery has just been released and is offered for sale on our website. Radem-Soft offers a 30 day trial period. We encourage you to download RapidQuery and try it out. Once the trial period ends, RapidQuery will have to be registered.

RapidQuery tool is an easy to use sql tool but yet very powerful.
The tool is aimed at programmers or professional staff who have basic knowledge of SQL language.
The tool is also useful for database administrators.

Database Client Software

The following table lists the installation prerequisites for connecting to the specified database server.

Connect

Fill up all the fields on Connect form. If your database has more parameters you have to add them on user field.
Usually you don’t need more parameters. Example for additional parameters:
SQL DIALECT=3

Table View

Choose the table name on the combo box and click on Table View tab.
Double clicking on the combo box text will put a “select * from “ on the sql editor and will open the query.

Open Query

RapidQuery can handle any sql statement, including Insert, Delete, Update and DDL.
The statement which appears on the sql editor is executed.
The result of the query will appear at Query Result tab. All statements will be added to the History.

Displaying Data

A grid displays the data in Table View and Query Result with a powerful Navigator.
The Navigator has the following functions:
Move to the first record, move back 10 records, move to the prior record, move to the next record,
move forward 10 records, move to the last record, insert new record, delete current record, edit current record, post changes,
cancel changes, refresh, bookmark, go to bookmark, filter, view current record in a form, located specific record, search.
Editing is possible only after clicking on Make Query Editable.

Execute Script

Similar to Open query with the following exception: RapidQuery will execute all the statements in the sql edit.
The statements have to be separated by semicolon(;).
All statements will be added to the History.

Load Sql

A file will be loaded into the sql editor.

Save Sql

The sql editor will be saved to a file.

Full Editor

A new window with a full editor will be opened

Query to Csv file

The query will be saved to a Csv file. The parameters from the Option form will be used. If there is no open query nothing will happened.

Query to Excel

The query will be inserted straight into excel sheet. Of course excel must be installed. If there is no open query nothing will happened.

Query to HTML

The query will be saved to an html file. The encoding from the Option form will be used. If there is no open query nothing will happened.

Query to XML

The query will be saved to an xml file. The encoding from the Option form will be used. If there is no open query nothing will happened.

Load into Table from Csv

An existing table will be loaded with data from a Csv file using the parameters on the Option form.
The data is appended or the table will be truncated before loading the data.

Tables to CSV Files

Like Query to Csv file but a list of table will be exported to Csv files. The Files names will be identically to the table name.

Query to Clipboard

The query result will be inserted into the Clipborad.

Save History

The history text on History tab will be saved to a file.

Clear Sql Editor

Clears the sql editor.

Clear History

Clears the history.

Refresh tables

The table names in the combo box will be refreshed.

Show Full List of Tables

The tables name will be showed on a form. The purpose it to allowed to copy and paste the table names.

Show Query fields Data Type

Shows the internal data types.

Make Query Editable

Allows making changes to data of the query. The navigator element can be used. If there is no open query nothing will happened.

Configuration

Allows editing the different options.

Copy Query to New Table

Copies the data from the query to a new table on any database (!).

Copy Tables to New tables – Migration

Copies the data from tables to new tables on any database (!).

Extract DDL

The known DDL is extracted. Bear in mind that the DDL have to be changed by your DBA.

The best way to copy data from database to database is:

1.  Extract DDL from the tables.
2.  Copy tables to CSV files.
3.  Change the DDL statements as you need.
4.  Create the tables with the DDL.
5.  Use the loader (of the target database) to load the CSV files into the tables.

  If you do not have loader then use "Load table from CSV".
  Mysql database loader is used when import tables from CSV files.

Registering

Please pay by Paypal 125$ and we will send in 48 hours by email the registry key.
Thank you for buying our product.
For any question about registering please contact us at Sales