Misc. Database Tools

SQL Examiner Suite includes 2 applications designed to visually compare and synchronize data between 2 MS SQL servers, or synchronize data from an outside source (e.g a backup database). The software provides a clear and easy to use workflow to select the data sources, specify tables and columns to compare and then presents you with the differences, automatically sorted three ways (different, only in 1, only in 2). You can then choose to perform a full or partial synchronization between the 2 data sources. The included SQL Data Examiner is designed to compare and synchronize table data, and the SQL Examiner can be used to compare all database objects, including Views, Users, Stored Procedures, Rules etc. Other features include smart scripting to prevent synchronization errors, comparison and synchronization of CLR objects, tracing of links between objects and more.

EMS Data Import for MySQL enables you to import data to your MySQL database, using MS Excel, MS Access, DBF, TXT, CSV or XML sources. It offers adjustable import parameters, including source/destination data formats, commit options, number of records to skip, and more. A step-by-step wizard allows you to configure all import options and then execute the operation.

CDBF is a powerful database viewer and editor that lets you access databases directly without programming via the familiar Windows interface. It offers everything you need for working with database files as well as integrated viewing and editing from the same window - just click on a field you want to modify and make the changes. You can also perform database-wide operations like case conversions, deletion of duplicate records and more. Filtering the view can be easily done by selecting a field and setting it as a filter criteria. CDBF supports all kinds of DBF files, including dBase III, dBase IV, FoxPro, Visual FoxPro and their memo fields. You can export the database tables to text files, DBF files, MS Excel format (.xls), Clipper and FoxPro source files (.prg) and SQL Server scripts (.sql). Many of CDBF features are implemented via the flexible plugins system, so the developers can easily add new functionality by simply placing their DLLs into the CDBF folder. Additional features include ability to edit memo-fields, print support, search and replace, automatic OEM/ANSI character set detection, exporting, deleting, recalling, summing and more.

DBScribe for SQL Server is a database documentation tool that creates detailed technical reports for every aspect of a database schema. You can choose the databases and tables to include, as well as server logins and jobs to document, and generate a report in HTML,CHM or MS Word format. The program provides complete control over which database details and object to include in the report (Stored Procedures, Triggers, Views, Defaults etc.)and you save the configuration as a scheme to be reused later. DBScribe for SQL Server offers an easy to use wizard interface and also supports command-line options.

dbOrchestra - SQL Server is an all-in-one SQL database development tool, that includes a database object browser and a SQL query tool. It provides quick access to database tables, views, stored procedures, triggers and other objects, as well as your custom SQL scripts. The program include a wide variety of admin features, that allow you auto-generate delete, insert, and update SQL scripts from the results of a query, build complex table joins, view database space usage and monitor server performance. Other tools include Data Comparison and Data Synchronization, Schema Comparison, Schema Migration, Database Instance Builder, File Manager and a lot more.

DBSync for Access & MySQL (formerly Access2MySQL Sync) enables you to convert Microsoft Access (MDB) databases to MySQL and vice versa. The program can import a MDB file directly into your mySQL server, and allows you to customize the import by selecting the fields and optionally changing field names and data types. The trial version allows for 10 full conversions.

DMT SQL Block Monitor enables database administrators to monitor Microsoft SQL Server blocked events in real-time. It displays the SQL query that was blocked along with other query details, allowing you to investigate the cause for the blocked process. In addition to real-time monitoring, the program also provides historical data and graphs for blocked events, as well as a variety of reports that enables you to identify top SQL queries by CPU and memory usage, query duration, frequency and other aspects.

EMS Data Generator for SQL Server enables you to generate test data for Microsoft SQL Server database tables. The step-by-step wizard lets you select the tables and fileds to be used. The program supports all SQL Server data types and allows you to generate the test data based on value ranges, characters masks, external sources or values retrieved from SQL queries. In addition to the wizard interface, EMS Data Generator for SQL Server also includes a console application to generate data from template files.

SQL Server Find is a database tool for use with Microsoft SQL Server. The program is very similar to the default Windows search dialog, but offers you you to search for database objects inside SQL servers using search criteria like: contains text (using regular expressions), creation date, object type (e.g. views, procedures, triggers), object name (using regular expressions) and object size. You can select one or more databases to include in the search and based on the given criteria, SQL Server Find goes out to find the database objects that match the specified criteria and displays them in a list. Right-clicking on a search result allows you to view the SQL source for the object.

DBScribe for MySQL is a database documentation tool that creates detailed technical reports for every aspect of a database schema. You can choose the databases and tables to include, as well as server logins and jobs to document, and generate a report in HTML,CHM or MS Word format. The program provides complete control over which database details and object to include in the report (Procedures, Triggers, Views, Relationships etc.)and you save the configuration as a scheme to be reused later. DBScribe for MySQL offers an easy to use wizard interface and also supports command-line options.

dbOrchestra - MySQL is an all-in-one SQL database development tool, that includes a database object browser and a SQL query tool. It provides quick access to database tables, views, stored procedures, triggers and other objects, as well as your custom SQL scripts. The program include a wide variety of admin features, that allow you auto-generate delete, insert, and update SQL scripts from the results of a query, build complex table joins, view database space usage and monitor server performance. Other tools include Data Comparison and Data Synchronization, Schema Comparison, Schema Migration, Database Instance Builder, File Manager and a lot more.

MSSQL-to-MySQL is a program to move MS SQL databases to MySQL server. Depending on your privileges on the target MySQL server you can export MS SQL data into new database or overwrite the contents of an existing MySQL database. The program uses an easy to follow step-by-step wizard that guides you through the conversion.

MySQL-to-Access is a program to convert MySQL databases into MS Access format. The program works with all versions of Unix and Windows MySQL servers and offers a fast conversion engine (10MB MySQL database - in 1 minute on average P-II system). MySQL-to-Access provides a simple step-by-step wizard interface that makes conversion a snap.

DBF Viewer 2000 is a user-friendly tool for viewing, editing and printing of DBF database files (Clipper, dBase, Foxpro, VFP, DB2K and others). It allows you to view and edit in OEM(DOS) or Windows character sets, get information about fields, find, sort, add, delete/undelete with wildcards, print or pack records. DBF Viewer 2000 does not require any external drivers to connect to an ODBC or BDE database. Additional features include export to HTML, customizable colors, data filters and more.

DMT SQL Decryptor enables database administrators to quickly decrypt stored procedures, views, user defined functions, table triggers, database triggers and server triggers in Microsoft SQL Server 2000/2005. You can view the decrypted objects, parse or execute the SQL and also export to text or RTF format. The program provides an easy-to-use interface with T-SQL syntax highlighting and a decryption wizard.

MetaReport allows you to create database reports, using various formats, including Access, dBase, Paradox, MS SQL, Oracle, InterBase and others. It uses ADO (ActiveX Data Objects) and BDE (Borland Database Engine) to build reports, but does not requires having BDE installed. When creating a report, you can choose from several layouts and then customize the design with text, images and shapes, using a WYSIWYG interface. You can drag and drop query elements into the report form, map field values to values or text of your choice, customize display format, font and more. MetaReport can also be used inside third-party applications as a built-in ActiveX object.

Data-to-PDF enables you to import relational data from a database, Excel or XML file and convert it to PDF format. The program supports local SQL and MySQL servers as well MS Access databases (.mdb files). You can choose to convert the entire database or load specific tables and optionally filter the data by running queries before generating the PDF output. Data-to-PDF allows you to customize the PDF files with header and footer lines, alternating row colors, table properties and font settings.

Access-to-MySQL is a program to move MS Access databases to MySQL server. Depending on your privileges on the target MySQL server, you can either export MS Access data into new database, or overwrite the contents of an existing MySQL database. You can also choose to export to a mySQL dump file first, and then import it to the server later. The program offers a simple 3-step wizard interface. Simply select the database, specify the mySQL server details and you`re ready to go. This version is designed for single database conversion, an additional Pro version for bulk conversions is also available.

dbLockdown protects SQL Server and MSDE databases by encrypting selected stored procedures, triggers and user defined functions and views, thereby stopping anyone from viewing or editing them. dbLockdown uses SQL Server`s native encryption and therefore does not compromise the functionality of database scripts. The encrypted scripts are automatically archived and can be restored at any time (they cannot be decrypted without restoring). Encrypted objects are not compatible with replication.

ExploreAccess is a tool to analyse an MS Access database and produce a list of statistics and details on the contents. The results can then be exported to a text file and used as an aid to debugging, future development or documentation.