CrystalNet Database Tool

This is a Microsoft Windows based database tool developed by CrystalNet Technologies LTD used by developers, DBAs and analyst for managing, administering and developing databases.


CrystalNet Database Tool also called CrystalDB Tool is a Microsoft Windows based database tool which is used by developers, DBAs and analyst for managing, administering and developing databases. This tool supports the two most common database management system, which are Microsoft SQL Server and Oracle. It provides an editor that offers code completion and syntax highlighting for standard SQL. It features a connection browser and a comprehensive set of database administration tools such as:

Database Management

The CrystalDB Tool provides database management functionalities which includes editing table data, creating or altering tables and views as well as database objects, backup and restore database etc.

Generate Scripts

This is a wizard in the CrystalDB Tool which allows the user to perform Data Definition Language(DDL) operations on the database objects. The DDL operations performed using this wizard include: ALTER, CREATE and DROP objects.

Import & Export Data

This is a wizard in the CrystalDB Tool which allows the user to create packages that import and export data between databases from different servers (MSSQL and Oracle), the same servers, spreadsheets, text files and XML Files.

Compare Databases

This is a wizard in the CrystalDB Tool which allows the user to compare the structure or the data in two databases both from the same server or different servers.

XML Explorer

This is a tool in the CrystalDB Tool which allows the user to view XML data from an xml file, excel file and any file which contains xml format and add a new xml data.

Query Builder

This is a tool in the CrystalDB Tool which provides an easy way to develop database queries by using a point-and-click interface and does not require in-depth knowledge about the SQL syntax.


For these databases which are commonly used in the industry we have added support for database specific features.
Some of these features are:
  • Edit Table Data
  • Auto Completion support in the SQL editor
  • Create/Alter Table support
  • Create/Alter Database objects support
  • Query Builder
  • Compare Data
  • Compare Schemas
  • Management of Databases, tables, views, triggers, synonyms, functions, procedures, etc.
  • Generate Scripts
  • Database Operations
  • Import and Export Data
  • XML Explorer
  • Database Management
  • Advance Data Search
  • Advance Object Search
  • Backup and Restore Database
  • Switch Oracle Client
  • Visual actions for CREATE, ALTER, DROP and so on
  • ...and much more

CrystalDB Tool is available in three editions:
  • Free Edition: Free of charge for commercial and non-commercial use. This edition provides basic level features useful for most users.
  • Standard Edition: Extends the Free edition with a must have tools for efficient work with databases.
  • Professional Edition: Extends the Standard edition with a set of tools for database developers and administrators.


CrystalDB Tool comes in three editions: Free, Standard and Professional.

Free Edition provides basic level features useful for most users.

Standard Edition extends the Free edition with a must have tools for efficient work with databases.

Professional Edition extends the Standard edition with a set of tools for database developers and administrators.

The matrix below compares features of CrystalDB Tools editions.

Features Free Standard Professional
Manage Database (Includes Create, Alter, Drop, Backup and Restore Database) No Yes Yes
Manage Schemas Yes Yes Yes
Manage MSSQL Database Collation Yes Yes Yes
Manage Indexes Yes Yes Yes
Manage Constraints Yes Yes Yes
Manage Triggers Yes Yes Yes
Manage Objects(Includes Add, Alter and Drop Database Objects) No Yes Yes
Manage Table Data Yes Yes Yes
Run Script Wizard Yes Yes Yes
Generate Script Wizard No No Yes
Database Operation Wizard No No Yes
Query Builder No No Yes
Import Data No No Yes
Export Data No No Yes
Compare Database (Compare Database Objects and Table Data) No No Yes
XML Explorer No Yes Yes
Excelâ„¢ Connection and Management Yes Yes Yes
Advanced Data Search No Yes Yes
Advanced Object Search No Yes Yes
Single License Price Free $99.99 $204.99

Operating System

  • Microsoft Windows XP
  • Microsoft Windows Vista
  • Microsoft Windows 7
  • Microsoft Windows 8
  • Microsoft Windows 8.1
  • Microsoft Windows 10
  • Windows Server 2008
  • Windows Server 2012

.NET Framework 4 or higher installed.

You can download .NET Framework here.

Note: .NET Framework is pre-installed in Microsoft Windows 7, 8, 8.1 and Windows 10.

Database Management System

Microsoft SQL Server

  • SQL Server 2000
  • SQL Server 2005
  • SQL Server 2008
  • SQL Server 2008R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016

Oracle

  • Oracle9i Database
  • Oracle Database 10g
  • Oracle Database 11g
  • Oracle Database 12c

5.0.0.2 18-Dec-2015
  • Improved analysis of comparison results
  • Stability and performance improvements
  • Usability improvements

5.0.0.1 01-Oct-2015
  • Improve Run Script Wizard performance
  • Data Comparison memory issue fixed
  • Dataview memory issue fixed
  • Issues with Excel import are fixed

5.0.0.0 11-Aug-2015
  • Added Compare Database Wizard
  • Added Generate Scripts Wizard
  • Added QueryBuilder Tool
  • Added Database Operations Wizard
  • Added Import/Export Data Wizard

4.0.0.2 13-Jun-2014
  • Fixed bug in Advanced Data Search functionalty
  • Fixed bug in Advanced Object Search functionalty

4.0.0.1 09-Mar-2014
  • Allow Saving Connections without password.
  • Fixed bug in Master/Details Screen

4.0.0.0 05-Jan-2014
  • Added Run Script Wizard
  • Added Excel Functionalities

3.0.0.1 29-Oct-2013
  • Improved DataView functionalities
  • Improved QueryEditor functionalities

3.0.0.0 13-Aug-2013
  • Added View Object Details for Oracle
  • Added Index, Constraints & Triggers Management
  • Added System, Connection, DataView and QueryEditor Options

2.0.0.1 25-Feb-2013
  • Stability and performance improvements
  • Usability improvements

2.0.0.0 15-Dec-2012
  • Added Database Management functionalities
  • Support .Net Framework 4.0 or Higher

1.0.0.0 01-Aug-2012
  • First release of CrystalDB Tool
  • Support .Net Framework 3.0 or Higher