Modern ribbon-based data manipulation tool for Microsoft SQL Server

Main features:

Quick database browser.

Query designer with data preview, design SELECT, UPDATE, DELETE, INSERT commands. Support for WHERE (NOT) EXISTS and OUTER/CROSS APPLY join operators.

SQL profiler – trace SQL server communication.

Data synchronization with support of relations. Ability to generate stored procedure from synchronization configuration.

ESRI shapefile viewer.

Find related data dialog, data duplicator.

Database structure compare and synchronization.

Advanced GPS visualiser, show GPS data from your database. Use Open Street Map, Google Maps, Bing Maps or more than 50 popular providers. Export map to HTML.

Database editor, view and and views, stored procedures, functions, triggers, table relations.

Advanced data filtering.

Search and hightlight matching data.

Export, import – CSV, HTML, SQL, MS Excel, XML, SHP, dBase DBF files. Data analysis without importing into database using query designer.

Generate SQL from data.

Exports and imports can be saved as jobs.

Database oriented perspective, database projects.

Database diagrams.

Table designer, edit columns, keys, uniques, checks.

Quick search in database model.

DbShell console.

Run queries, generating query templates, code completion.

Cell data viewers and editors (text, XML, image, hexa, GPS-data using OpenStreetMap, GoogleMaps etc.)

Display data from referenced tables.

Ability to extend table display for linked columns.

Master/detail views.

Store queries as «client views» with ability to filtering and sorting.

Handy shortcuts to database objects (favorites).

Local storage for table data, local databases (using SQLite database engine).

Data widgets.