DbTools 1.07
DbTools comes with tools for scanning and manipulating data in relational databases (programs DbLoader, DbExport, DbView, Console).
|
DbTools comes with tools for scanning and manipulating data in relational databases (programs DbLoader, DbExport, DbView, Console). As for database connections, DbTools software use ODBC. This way have a fundamental advantage - the independence from a database engine.
You can (for example) export data from MS Access database by using the DbExport program and then import this data into database Oracle by using the DbLoader program. DbTools software is helpful for any data migrations between different databases. If you use CREATE scripts for building your databases, the program DbLoader and it's console version Console are able to make database files from scripts quickly.
Program DbLoader.
This program is useful for importing data from SQL scripts to databases. If you have SQL script (the text file with SQL commands) for certain databases (for example MS Access, MS SQL Server, Oracle, ...), the program DbLoader is able to connect to these databases and execute SQL commands. The program DbLoader supports transactional executing using rollback and commit commands - also for databases, which doesn't support transactional executing under normal conditions (for example MS Access). We are able to use all SQL commands, which are supporting to a relevant database platform. You can use INSERT, UPDATE, DELETE, ALTER TABLE commands... . It is necessary in working with the DbLoader program to have knowledge of the SQL language (for certain database platform).
Program DbExport.
This program is useful for exporting data from database to the text file (SQL script). You can connect to a database, where the data is in database tables, and make SQL script from the DbExport program. If this script is ran (by the DbLoader program), data can be imported to other databases. The program DbExport makes two kinds of scripts - CREATE scripts and INSERT scripts. CREATE scripts contain CREATE TABLE commands. If these commands are run (on other databases), empty database tables will be created. These empty database tables can be filled with data from the INSERT script. The INSERT script is a succession of INSERT commands. You can also change formating of new SQL scripts - adjust the date format, location of commit commands, type of database variables, etc... in the DbExport program.
Program DbView.
This program is useful for looking through databases. It can show what tables are in a database. For the chosen table, we display it's indexes and fields. You can look through contents of database table too. All information in DbView program screens are read only.
Program Console.
This is the console version of the DbLoader program. This program can be run from the command line in the MS-DOS window. All controls of this program are accessible through a so-called master script. This master script governs connections to databases, the executing of SQL scripts, and database disconnecting. GUI from the DbLoader program is more user-friendly then the console solution from the program Console, but in the Console program, we provide the option of automating all actions.
tags
this program the dbloader dbloader program the program from the you can program dbloader data from useful for sql script database tables sql commands sql scripts

Download DbTools 1.07
Similar software
DbTools 1.07
Roman VINCZE
DbTools comes with tools for scanning and manipulating data in relational databases (programs DbLoader, DbExport, DbView, Console).
DBExport 4.93
Scalabium Software
DBExport offers you a lot of advanced tools to export your database table to the external files (CSV, XLS, HTML, XML, RTF/DOC, SQL-script and more).
Ezy Data 2000 4.2.1
aadconsulting.com
Ezy Data 2000 lets you easily create relational databases of tables and queries for entering, storing, viewing and analysing data.
MetaTrieve 1.0
MetaTrieval Software
MetaTrieve is an enterprise-wide search engine and query tool for relational databases, XML documents* and legacy files**.
Visual Basic Database Projects 1.0
Kidware Software
VISUAL BASIC DATABASE PROJECTS is a free and useful utility which contains three different programs for your use.
MindModel 2.82
MindModel Corporation
MindModel is very easy-to-use relational database software that allows you to store and recall information on any topic.
SQL Batch Suite 1.01
UriSoft
One of the most popular features in reporting tools is exporting the results to MS Excel for further analyses.
Advanced Database Query 1.0
Advanced Reliable Software
Advanced Database Query is a relational database client tool which allows execution of SQL (Structured Query Language) statements on Microsoft SQL Server and MySQL databases.
WinSQL Lite 5.5.60.568
Synametrics
WinSQL is an ODBC compliant database development solution that streamlines day-to-day tasks related to databases
WinSQL works with any ODBC compliant database including, but not limited to, Oracle, Sybase, DB2, MS SQL Server, Informix, MS Access, MySQL, PostgreSQL, and more.
Microsoft SQL Server 005 Service Pack 2
Microsoft
SQL Server 2005 is a comprehensive database software platform providing enterprise-class data management and integrated business intelligence (BI) tools.