EMS logo

Live Chat with Sales rep.

We will be happy to answer any sales or upgrade questions that you have. We can chat online or you can call us.
Toll-free for U.S. & Canada: 1-866-SQL-4-YOU (1-866-775-4968)

Velaro Live Help | Learn More

News

07/21/2008
SQL Manager for PostgreSQL version 4.4 released
Backup database and Restore database wizards added, support of planner options is added for version 8.3, support of PostGIS geometry type and many other improvements…
05/22/2008
Data Export version 3.1 released
Added the possibility to select the file encoding when exporting to TXT and generate the 'IDENTITY_INSERT' SQL statement; a lot of new features, improvements and bug-fixes for different servers…
04/29/2008
SQL Manager for DB2 version 1.1 released
Support of new objects (Audit Policies, Trusted Contexts, Roles, etc.) and data types (XML, DECFLOAT, VARBINARY, etc.), support of the SECADM privilege added and many other new features and bugfixes…
04/10/2008
SQL Manager for SQL Server version 3.2 released
Service Broker support; support of SQL Server 2008 features: table types, logon triggers, new backup parameters; SQL editors improved, and many other improvements…
04/10/2008
DB Comparer version 3.1 released
Comparing process is significantly improved, modifying scripts are generated correctly and many bugfixes are implemented…
04/08/2008
Advanced Data Export VCL version 4.0 released
New data export components and Unicode support added, support of BDS 2007, Delphi 2007 and C++ Builder 2007 and other improvements…
04/02/2008
SQL Query version 3.1 released
Faster connection to databases, the ability to save program settings to a REG file is added, and other improvements and bug-fixes...
02/20/2008
SQL Manager for MySQL version 4.3 released
Added UTF8 support for metadata and support of the FEDERATED table type, added the Find Option tool and the Search Panel in the DB Explorer, lots of other improvements and bug-fixes…
02/05/2008
SQL Manager for PostgreSQL version 4.3 released
Support of new PostgreSQL 8.3 features, SQL editors are improved, a lot of other improvements and bug-fixes…
News Subscribe | More News

EMS SQL Management Studio ™

Become more productive than ever before!

EMS SQL Management Studio is a complete solution for database administration and development. SQL Studio unites all must-have components that focus on the most critical database management tasks in one powerful and easy-to-use environment that can work round the clock. Whether you are a database or application developer, DBA or business analyst, EMS SQL Management Studio offers all essential tools to make you more productive than ever before!


Learn more about EMS SQL Studio:

Database Management Tools

SQL Manager
Simplify and automate your database development process, design, explore and maintain existing databases, build compound SQL query statements, manage database user rights and manipulate data in different ways.

Database Conversion and Migration Tools

Data Export
Export your data to any of 19 most popular data formats, including MS Access, MS Excel, MS Word, PDF, HTML and more.
DB Extract
Create database backups in the form of SQL scripts, save your database structure and table data as a whole or partially.
Data Import
Import your data from MS Access, MS Excel and other popular formats to database tables via user-friendly wizard interface.
Data Pump
Migrate from any ADO-compatible sources to MySQL, PostgreSQL, SQL Server, InterBase/Firebird, Oracle or DB2 databases.

Database Analysis Tools

Data Comparer
Compare and synchronize the contents of your databases. Automate your data migrations from development to production database.
DB Comparer
Compare and synchronize the structure of your databases. Move changes on your development database to production with ease.
SQL Query
Analyze and retrieve your data, build your queries visually, work with query plans, build charts based on retrieved data quickly and more.
Data Generator
Generate test data for database testing purposes in a simple and direct way. Wide range of data generation parameters.

Components and Tools

Advanced Data Export
Save your data from your application in the most popular data formats for future viewing, printing or web publication.
Advanced Data Import
Load data to your database from files in the most popular data formats. Don't waste your time on tiresome data conversion.
Advanced PDF Generator
Create PDF documents within your applications in the most simple and easy way without any knowledge of PDF format.
Advanced Query Builder
Build new complex SQL queries for many SQL dialects and represent the existing queries visually within your applications.
Advanced Excel Report
Create powerful template-based reports directly in MS Excel format from your Delphi applications with ease.
Advanced Localizer
Add multilingual support to your applications. Localize your Delphi projects without writing a single line of code.
Source Rescuer
Restore your lost source code from executables and get all project forms and data modules with all assigned properties and events.

Free Database Tools

Create a work environment that is efficient and free with our freeware easy-to-use products for database development and administration. Take advantage of the freeware database tools from EMS Database Management Solutions to increase your productivity. Learn more about free database tools

SQL Industry News

02/05/2008
PostgreSQL 8.3 released
The PostgreSQL Global Development Group today announced the release of version 8.3 of the high-performance object-relational database management system...
01/17/2008
Oracle has released its first critical patch update of 2008 with 26 new security fixes
Oracle has released its first critical patch update of 2008 with 26 new security fixes.
01/16/2008
PostgreSQL 8.3 Cheat Sheet Overview
Postgresonline.com community created a Cheat Sheet that covers prior PostgreSQL constructs plus new 8.3 features
12/13/2007
Microsoft Releases Entity Framework Beta 3
Microsoft released Entity Framework Beta 3 and officially announced that third-party database vendors agreed to support the framework
News Subscribe | More News | XML content. Requires RSS support to view.

SQL Articles

MySQL AB
MySQL 5.1 partitions in practice
This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions.
Muthusamy Anantha Kumar
UNIQUE Column with multiple NULL values
In this article, author illustrates how to maintain uniqueness on a column and also allow multiple NULL values...
Sean Hull
Oracle, MySQL and PostgreSQL feature comparison – Part 2
Though the feature sets certainly differ between Oracle, Postgresql, and MySQL, most of your daily needs are met in these areas. This time around, we'll hit upon some areas where the platforms differ more significantly
MySQL AB
A Primer on Falcon Tablespaces
This article takes a quick look at how tablespaces are used within Falcon and what you can and can’t do with them.
News Subscribe | More Articles | XML content. Requires RSS support to view.

Products Navigation

choose your database tool

Our customers

Testimonials

First of all I want to congratulate you for such a wonderful products. I also wanted to express my admiration for such a wonderful customer service.
Jürgen Kappler

Our Partnership Status

MySQL Gold Certified Partner
Microsoft Gold Certified Partner
Oracle Certified Partner
Borland Technology Partner
CodeGear - Where Developers Matter