Introduction

Thank you for your interest in DB Commander 2000.

DB Commander 2000   is an all-in-one database tool. Ideal for handling many types of databases where copying/transferring of table structure and records takes place.   It can manipulate two databases, of any type, at the same time. Create duplicate copies of tables in existing databases and copy table structure and/or data across different database types - even from a query result set. Delete/empty tables, create/delete indexes or use SQL statements to perform any type of query.  Plus much more.

It's a must have database tool!

DB Commander 2000 connects to any SQL based database supported by BDE*, such as Oracle, Sybase, MS SQL, Interbase, Informix, MS Access, MS Works...

*BDE (Borland Database Engine) required and included with software.

What can DB Commander 2000 do?

            View/Edit Two Tables of different database types at the same time.

         Copy Table structure to another database with indexes intact if applicable - one or more tables at a time.

Table structure can also be created from a query result set.

         Transfer Records across to another table – one or multiple tables at a time. DB Commander will transfer even if

the tables are not identical. This can also be done from a query result set.

         Transfer Selected records to another table.

         Transfer records between tables by mapping their fields.

         Delete Tables - one or more tables at a time.

         Empty Tables (Clear the contents) - one or multiple tables at a time.

         Rename Tables.

         View/Create/Add/Delete Indexes.

         Add/Delete Columns (Fields) to existing tables and/or transfer the contents of a single column (field).

         Execute any query, even scripts, using SQL statements.

         Export/Import to/from a text file.

         Preview the contents of any table including the contents of a query result.

         Export the contents of any table to an FTP site (in text).

         Quick comparison of count of Tables, Records, Fields, Indices & Primary Keys between databases.

         Plus much more.

 

For a quick handling of the above-mentioned options simply right-click on the side you wish to have

an action performed.

 

Note:    To connect to SQL Based databases you must connect via a BDE/ODBC alias.

            You can access the BDE Administrator from the control panel. 

            Consult the BDE Help files on how to setup a Database Alias.

            Use the File/Open dialog to open Paradox/Dbase or Interbase databases only.  

            All other databases (SQL databases) need a correctly configured alias, using the BDE or ODBC Administrator. 

 

 How to create a copy of a Table

 To create a copy of a Table (table structure only) 

           Connect to a database. For SQL databases, connect using the alias drop down.

         Select the table you want and open it.

         From the Utilities menu choose “Create a copy of “ and choose the side on which to create the copy of the table.

         If you are creating the copy over to another database make sure you are connected there as well.

 

To mass-create all tables from one database to another

           Connect to a database on both sides.

         From the Utilities, menu choose “Mass-copy Tables” and choose the side on which to create the table copies.

 

To select tables to copy from one database to another

 

         Connect to a database on both sides.

         From the Utilities menu, choose “Multi-Select Copy Tables” and choose the side on which to create the table copies.

  

How to transfer data to another table

 To copy the data of a Table on to another table

           Connect to a database on both sides. For SQL databases, connect using the alias drop down.

         Select the table you want and open it.

         From the Utilities menu, choose “Transfer Data” and choose the side on which to transfer the data of the table.

 

To mass-transfer the data, all tables from one database to another

           Connect to a database on both sides.

         From the Utilities menu, choose “Mass-Transfer Data” and choose the side on which to transfer the data.

 

To select tables to transfer their data from one database to another

           Connect to a database on both sides.

         From the Utilities menu, choose “Multi-Select Data Transfer” and choose the side on which to transfer the data.

         From the form simply select the tables and click transfer.

 

 

How to copy/transfer selected records from one table to another

           Connect to a database on both sides. For SQL databases, connect using the alias drop down.

         Select the table you want and open it.

         Select the records you wish to transfer. You can select them by holding the “Ctrl” key down and clicking on the records with the mouse. If the records you want to select are all in sequential order, you can hold the “Shift” key down and use the arrow keys to select them.

         From the Utilities menu, choose “Transfer Data” and choose the side on which to transfer the data of the table.

 

How to copy/transfer records from one table to another by mapped fields

           Connect to a database on both sides. For SQL databases, connect using the alias drop down.

         Select the tables and open them.

         From the Utilities menu select “Mapped Transfer” and choose the From/To side.

         Select the fields one by one from the “From” side and drop them onto the “To” fields to map them.

         Once mapping is completed, click on the “Start Mapped Transfer” button.

 

How to empty the contents of a table

           Connect to a database.

         Select the table you want to empty.

         From the Utilities menu, choose “Empty Table”.

 

Note: You can mass-empty all tables from a database or do a selective emptying of the tables.

 

How to delete a table

           Connect to a database.

         Select the table you want to delete.

         From the Utilities menu choose “Delete Table”.

 

Note: You can mass-delete all tables from a database or do a selective delete of the tables.

 

How to run SQL statements

           Connect to a database.

         From the Utilities menu choose “Run SQL Statements”.

 

How to Add/Delete indexes

           Connect to a database.

         Select the table.

         From the Utilities menu, choose “Index”.

 

To Add an index

           On the form that will pop-up you can double-click on the fields that you wish to index.

         Name the index and click on the “Add” button.

 

To Delete an Index

           Select the index in the index window.

         Click on the “Delete” button.

 Note: You can view all the main details of the fields of the table you are viewing by clicking on the “Detail” button.

 

Tip: If for any reason the addition or deletion of an index fails, you can use the SQL Editor of

the program by clicking on the “Run SQL Statements” button and try to execute SQL commands

for the specific task.

 

How to Add/Delete columns from a table

 To Add/Delete Columns (Fields)

         Connect to a database

         Select the table.

         From the Utilities menu, choose "Add/Delete Columns".

 

 To Add

         On the form that pops-up, enter a name for the column and select the type and length of the column

 to be added and click “Add”.

 

To Delete

         On the form that pops-up, select the column you wish to remove and click “Delete”.

 

Tip: If for any reason the addition or deletion of a column fails, you can use the SQL Editor of

       the program by clicking on the “Run SQL Statements” button and try to execute SQL commands

       for the specific task.

 

How to create a table from a query result set

           Connect to a database on both sides.

         Bring up the SQL editor by clicking on the “Run SQL Statements” button.

         After executing an SQL statement that returned a result set, click on the “Create Table Over” in the “Utilities” menu. 

         Name the table. (No extensions)

 

How to transfer data from a query result set

           Connect to a database on both sides.

         Select the table on which to transfer the data – opposite of the database where the query will run against.

         Bring up the SQL editor by clicking on the “Run SQL Statements” button.

         After executing an SQL statement that returned a result set, click on the “Transfer Data Over” in the “Utilities” menu.

 

How to Export/Import data

 To Export

        Connect to a database.

       Select the table.

       From the Utilities menu, choose “Export to ASCII file.

       From the form that pops-up, select the delimiter, the path and filename to export to.  You can also export to an FTP site.

       Click OK.

To Import

      Connect to a database.

       Select the table.

       From the Utilities menu, choose “Import from ASCII file to" and select the table.

       From the form that pops-up, select the file name and the type of data.

       Click OK.

Note: Cannot export/import Blob data here.  

Use the File/Open dialog to open Paradox/ Dbase or Interbase databases only