Top Rated Scripts | Tools & Utilities | Database Tools

XpressProps is a SQL Tool designed to enable documentors and developers to add and maintain extended properties for all objects in SQL Server 2000. Where as the Query Analyser only allows you to maintain certain object XpressProps for MS SQL Server 2000 allows all Extended Property to be maintained for an object.

Sync Database is easy solution to synchronize schema of mySQL databases. When you alter database, add or change columns, indices or constraints, sync is done in an quick and painless process and enables you to change the structure of your older database to its newest version while preserving its data. 1. Select source database or load an SQL script. 2. Select target database (you can also create it using builtin script editor) 3. Synchronize!

Advanced DBF Repair (ADR) is a powerful tool to repair corrupt DBF files. It can scan the corrupt DBF files and recover your data in them as much as possible, so to minimize the loss in file corruption. Currently ADR supports to fix dBASE, FoxBase, FoxPro and Visual FoxPro database. Moreover, it has integrated with Windows shell, supported drag & drop operations and command line parameters, which will make you repair DBF files easily and quickly.

DBSP (Data Base Scripting Pages) is a new server-side scripting technology designed specifically for the exploitation of databases across the Internet. The strongest quality of DBSP is time spent in development cycle. With DBSP you could deliver complex database oriented Web solutions in weeks. DBSP allows you to focus in solving your customer needs instead of wasting your time in solving technical issues.

The FileMaker 7 AppleScript Reference document provides a quick reference guide to commonly used FileMaker 7 AppleScript commands. This document provides a description of each code example, the FileMaker 6 example code, and the FileMaker 7 example code. The FileMaker 7 version of this document enables developers to copy and paste example code directly from each field of the database.

Advanced Access Repair (AAR) is a powerful Access recovery tool. It will scan the corrupt or damaged Access databases and recover your data in them as much as possible, so to minimize the loss in file corruption. Currently AAR supports to recover Microsoft Access 95,97,2000,XP,2003 databases. Moreover, it is integrated with Windows Explorer, supports drag & drop operations, which will make you repair Access databases easily and quickly.

AdventNet SwisSQL offers SQLOne Console, an easy to use Graphical user interface tool to convert SQL queries from one dialect to another. DB Administrators and developers working with multiple databases can just type a query in one SQL dialect and view the equivalent query in different databases’ dialects. It supports Oracle, MS-SQL Server, DB2, Informix, Sybase, MySQL, PostgreSQL and ANSI-SQL SQL dialects.The product is available in both Java and Visual Basic Editions.

WDReportGen is a report generator for Microsoft Word that outputs reports in Microsoft Word document format. If you know how to use Microsoft Word and write SQL statements, you can use WDReportGen to create all kinds of reports as you need. Features: * Using Microsoft Word as your reporting tool * Making report template directly using Microsoft Word * Accessing databases using SQL * Creating reports without programming experience * Connection to all databases using ODBC * Supporting multi-databases in one report * Generating reports with parameters * Supporting Windows mode and command line mode * Creating complex reports * Creating reports with pictures * Many reports in one Microsoft Word document * Conversion of file formats * Generating reports automatically * One time configuration * Flexible deployment

XLReportGen is a report generator for Microsoft Excel that outputs reports in Microsoft Excel spreadsheet format. If you know how to use Microsoft Excel and write SQL statements, you can use XLReportGen to create all kinds of reports as you need. Features: * Using Microsoft Excel as your reporting tool * Making report template directly using Microsoft Excel * Accessing databases using SQL * Creating reports without programming experience * Connection to all databases using ODBC * Supporting multi-databases in one report * Generating reports with parameters * Supporting Windows mode and command line mode * Creating complex reports * Creating reports with pictures * Many reports in one Microsoft Excel workbook * Conversion of file formats * Generating reports automatically * One time configuration * Flexible deployment

MySQL Service Center is a multi-functional Windows GUI utility for MySQL server maintenance and data reservation. MySQL Server Center allows you to create tasks for backing your data into a script, restoring data from a script, analyzing, checking, repairing and optimizing database tables. In addition to these functions, MySQL Server Center provides you with a powerful task scheduler, ability of using scenarios and other useful features.

This is a new and powerfull SQL Server tool that enables you to run a search & replace throughout your entire TSQL code - Stored procedures, Functions, and Triggers. In addition, it helps you find the database entities you are looking for, across databases and servers using multiple criteria, and then presents search results in a very intuitive, yet powerful format. A 30 day trial is available for free.

AddressDoctor for Excel is a powerful Add-In for data cleansing. It connects to the world's most complete database of place- and streetnames to correct postal addresses within minutes. You can verify addresses from 240 countries and territories without installing any reference data at your desktop. Up-to-date directories are provided via secured online connections. Efficient algorithms make sure that even incorrectly fielded data is restructured and verified. The trial version allows you to cleanse 250 postal addresses for free.

SQL Uniform is a database client, graphical user interface (GUI), a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert), import. It supports any kind of database and database servers to which there is an ODBC or JDBC standard driver. It has been tested on the following databases: Access, Adabas D, DaffodilDB, dBASE, Excel, HSQL, IBM DB2, Interbase (Firebird), JDataStore, Linter (Relex), McKOI, Mimer, MSSQL, MySQL, Openlink Virtuoso, Oracle, Paradox, Pervasive (Btrive), Pointbase, PostgreSQL, Quadcap QED, Solid, SQLITE, Sybase, ThinkSQL, Yard. When starting the program for the first time, you can decide which mode of the program to be used. You can choose between freeware (Lite) and shareware (Professional) mode.

Visual Integration Studio is a visual integration design environment for extracting, transforming, and loading (ETL) data from any data source � to any data source using a simple drag and drop, property based interface. Plus, you can code any type of data transformation logic in standard Visual Basic .NET!

Full Convert provides you with comfortable way to convert data between many different databases. For highest possible speed and reliability, Full Convert uses native access to databases wherever possible. Currently, native connections are used for Interbase/Firebird, MySQL, Oracle and SQL Server databases. Full Convert 1.0 supports following databases (future version will support even wider variety of data formats) - Microsoft Access - dBase - Microsoft Excel documents - Interbase / Firebird - Lotus 1-2-3 - MySQL - Oracle - Paradox - SQL Server - Delimited text files All editions feature target database browser with multiselect which greatly simplifies certain actions. Standard Edition Standard Edition supports (besides conversion itself) dropping of all tables or selected tables/columns. Professional Edition Professional Edition adds a powerful action and parameters handling. Similar tools require that you make mappings from source tables and columns to target, often with cumbersome interface to handle the amount of data displayed. Full Convert makes a swift conversion and puts you in control of target database with additional functionality which enables you to transform database and data structure with ease. Extract several columns to a new table leaving a referencing column, merging data from a table into another, renaming tables and columns and changing their properties, drop unused columns or tables, conditional data changing using your own parameters... Not to mention you can see how many records each table has so you know where your data is. Full Convert remembers all actions and stores them in saved session file. Next time you want to convert, all you have to do is press a button and all your actions are executed after conversion over new data and with no additional work from your side

EMS SQL Manager for InterBase/Firebird is a powerful tool for InterBase and Firebird administration and development. SQL Manager 2005 is compatible with any Firebird version up to 2.0 and InterBase version up to 7.5 and supports all of the latest features including trigger messages, BLOB filters, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder and Stored Procedure Debugger to satisfy all their needs. SQL Manager 2005 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML columns, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer and Visual Query Builder to satisfy all their needs. SQL Manager 2005 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

EMS DBISAM Manager provides you with powerful tools for DBISAM Server administration and object management. Its Graphical User Interface (GUI) allows you to easily and simply create/edit all DBISAM database objects, run SQL scripts, manage users and administer user privileges, visually build SQL queries, extract and print metadata, export/import data, view/edit BLOBs, and supplies many more features that will make your work with the DBISAM server as easy as ABC.

EMS Data Generator for MySQL is a powerful utility for generating test data to several MySQL database tables at once. The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists of values from SQL queries and many other features to generate test data in a simple and direct way. It also provides you console application, which allows you to generate data in one-touch by using generation templates.

EMS DB Comparer for MySQL is an excellent tool for database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to eliminate all or selected differences. Having EMS DB Comparer for MySQL you can work with several projects at once, define comparison parameters, print difference reports, and alter modification scripts. Its user-friendly interface greatly simplifies discovering and eliminating differences in MySQL database structure saving your time and therefore money.