AlligatorSQL is the first cross development and cross administration IDE for both DBAs and developers. We integrated not only seven database management systems, but also combined development and administration features consequently into one tool. As a result AlligatorSQL is specialized for heterogeneous infrastructure and enables the user to develop, administer and monitor his database management system simultaneously. AlligatorSQL Enterprise Edition supports Oracle8i/9i, DB2, MSSQL (SQL Server 2000), MySQL, Interbase, PostgreSQL, Ingres and Birdstep (Velocis).
Main feature list: Project Management, Connection Folder, Multithreaded Browser with direct edit and Autofilter, Multiple join, Simultaneous Access, Explan plan, Sourcecode checker, Profiler, Post Mortem Debugger, Tablespace Checker, DBA Toolbox, Performance Monitoring, User Management, Process Management, Office Integration, Adaptor Scripting
oracle mysql interbase database tools utilities db2 mssql sqlserver ide dba
The application "Scripper" is intended for performance of the script of changes of structure of a database InterbaseServer of the version 6.0. The script to represent by itself a textual file with expansion *.txt or *.sql, which is easily edited and is looked through in the standard text editor "Notebook". The text of the script is made in language SQL (language of the structured inquiries) Dialect 1.
script database interbase firebird application scripper intended performance script changes
CASE Studio 2 is a professional and intuitive database design tool, which allows you to visually create Entity Relationship diagrams (ERD) for various database systems. It includes a full support of the following databases: Oracle, DB2, MS SQL, InterBase, MaxDB, MySQL, PostgreSQL, Sybase ASE, MS Access, Firebird, Advantage Database Server, Ingres, Informix, Pervasive V8, DBISAM and several others. When creating ERD the program considers individual database options such as referential integrity, constraints, domains, triggers, user permissions etc. CASE Studio 2 provides a gallery for saving and storing most frequently used parts of models or a dictionary with predefined user data types. Moreover, data flows between tables can also be easily described by creating appropriate Data Flow Diagrams (DFD).
Key features also include: universal reverse engineering, which allows you to reverse engineer already existing database structures; version manager; creation of very detailed HTML and RTF reports; SQL/DDL scripts generation; ER-diagrams comparison; conversion of ER diagrams into other databases; pattern editor for triggers, views and stored procedures; support of JScript and VBScript, export of diagrams into graphic files and many more.
case er diagram case studio database model design tool ddl sql script
Database Comparer helps to compare, synchronize and update databases structure. You can compare one database with another database or database with DDL/SQL script or even two DDL/SQL scripts!Database Comparer supports following servers: InterBase SQL server and it's clones - FireBird and Yaffil (Yaffil team recently announced merge with FireBird); SQL Anywhere. Borland InterBase Express components library (IBX) is used by default to work with InterBase / FireBird. Alternatively Database Comparer supports Fast InterBase Plus components by Devrace (FIBPlus).Delphi demos code; Full indexed help system.Installations for Delphi 5, 6 and 7.
synchronize compare update database ddl script metadata sql interbase firebird ib ibo
Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources.
Very fast and reliable. Uses naitive API.
Oracle 7-9i database (using OCI API)
SQL server 7- 2000 (using BCP API)
ODBC source (using ODBC API)
Any ODBC source
MS Sql Server
This product features:
Great performance - hundreds of records per second
Rejected records file
Integrated Expressions builder
Allows the user to perform calculation during the loading process such as splitting fields, concatenations, data formatting, and loading cross/pivot tables.
There are two ways of loading available:
Oracle direct path loading
MS SQL server
This software uses the same API as Microsoft DTS service.
Any ODBC compliant database.
Other features are:
Easy Repository switching
SQL scripts editor
oracle ms sql server bcp sql loader odbc etl datawarehouse repository ms access oracle ms sql server
Database Workshop is a professional multifunctional tool for working with databases and database objects. It uses the modern plug-in module technology that combines flexibility and versatility for working with various databases. First and foremost, Database Workshop is a data processing solution with data analysis options that can copy, export and import data to other tables. Currently, the program supports InterBase, MySql, Ms Sql, Ms Access, DBISAM, FlashFiler, KeyDb, EasyTable, TinyDb, VolgaDb, Clarion, Paradox and dBase databases. Using Database Workshop, you can perform data manipulations within a fraction of time and with much less efforts it used to take you before.
database interbase dbase paradox mysql bde delphi database workshop 5 program
Interbase Backup Watcher allows you to create Backup databases under the control of Interbase 6.x server. Having customized this program once, you can forget about a problem of the data backup. Interbase Backup makes databases' backups automatically.
The program has a simple and convenient interface for customizing the backup structures.
While using Backup Watcher for Interbase you create a structure, in which you specify a site of the server, a database, backup files, settings of the backup process and when it should take place.
interbase firebird yaffil sql backup copy compress compression mirroring safekeep password protection pkzip
XML/XSLT Maker is a code generator that can create dynamic, XML/XSLT-based Websites from databases in no time. Supported databases includes Microsoft Access, Microsoft SQL Server, Oracle, or any database with ADO or ODBC connectivity.
XML/XSLT Maker can automatically generate both ASP (Active Server Pages) for content and XSLT (Extensible Stylesheet Language Transformation) stylesheet for layout. Using the generated ASP and XSLT stylesheets, users can add, delete, edit, view and search data in the database easily on the Web. The generated code is readily usable, straightforward and easy-to-customize.
xml xslt xpath asp iis mdac ms access access sql sql server mysql
1. IBLogScript - scripting tool for replication and cancel of data changes for Interbase.
IBLogScript is intended for IBExpert (v.184.108.40.206 or later) users working with IBExpert data changes log.
(IBExpert log machine is a set of tables and triggers for data changes tracing. IBExpert automatically generates this set)
If You already work with this convenient capacity, but need a tool for data changes cancel or transference from one sister database to another, IBLogScript will help You.
IBLogScript creates SQL script for replication or cancelling of data changes logged by IBExpert (in tables IBE$LOG_TABLES, IBE$LOG_FIELDS etc.)
2. User's directions
Just specify database file name, user name, password and script type (reproducing - canceling) and execute (F9), then save resulting script in file or copy it to clipboard.
To show in script date and user info (who and when made this data change) set checkbox "Include date and user comments" to true.
You can also restrict period of data changes that will be included in resulting script by specifying right period dates.
3. Known limitations
BLOB fields updating is not supported yet.
4. Development plans
BLOB fields updating realization is planned by means of XML-based data changes log transference.
interbase firebird ibexpert log script data changes ibe-log_tables ibe-log_fields scripting tool
MetaReport allows you to build any reports: from simple data retrieval to complex professional reports. Using MetaReport you can easily create reports from data stored in Access or Paradox database as well as from Oracle or MS SQL database servers. MetaReport supports most data source formats: Access, dBase, Paradox, MS SQL, Oracle, InterBase and others.
Next time you run a created report, it will be with one mouse click and save report results into a specified format. MetaReport supports exporting to many popular file formats: TXT, WMF, HTML, RTF, XLS, PDF, CSV.
You can specify report parameters using a simple dialog box before generating.
For developers: you can easily integrate MetaReport with your application using the ActiveX object.
Main MetaReport features:
Data access. While accessing data, MetaReport uses the ADO (ActiveX Data Objects) and BDE (Borland Database Engine) technologies without the need to have BDE installed. In this case, MetaReport can access the database with only using ADO.
Powerful designer allows you to create quite complex reports to meet nearly all requirements.
The report parameters dialog box allows you to specify various parameters of data retrieval without modifying the report itself. To create a dialog box, MetaReport has a visual constructor.
Saving results in various formats. MetaReport supports exporting to the following file formats: TXT, WMF, XLS, HTML, RTF, PDF, CSV (comma-separated text).
The built-in ActiveX object allows you to easily use MetaReport in your applications created in any development environment. At the same time, MetaReport will work with your application as a whole.
Locking the report designer allows to protect ready report projects from an unintentional change by an inexperienced user.
database activex meta sql ado bde report designer constructor export rtf