EMS logo

Products Navigation

choose your database tool

Our customers

Testimonials

I have used your SQL Manager for PostgreSQL product in the past and figured this was certainly worth buying again for our MySQL development. Congratulations on having such a great product. The MySQL and PostgreSQL communities benefit greatly from having you guys around.
D. Dante Lorenso

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

Live Chat with Sales rep.

We will be happy to answer your questions. Please chat or call us: 1-866-775-4968 (toll-free for U.S. & Canada)

News

05/16/2013
EMS Advanced Localizer updated
Embarcadero RAD Studio XE4 support added...
05/16/2013
EMS Advanced Excel Report updated
Embarcadero RAD Studio XE4 support added...
05/16/2013
EMS Advanced Query Builder updated
Embarcadero RAD Studio XE4 support added...
05/16/2013
EMS Advanced PDF Generator updated
Embarcadero RAD Studio XE4 support added
05/16/2013
Advanced Data Import VCL version 3.8 released
RAD Studio XE4 support added, and much more...
05/16/2013
Advanced Data Export VCL version 4.9 released
RAD Studio XE4 support added, and much more…
04/08/2013
EMS SQL Manager for PostgreSQL version 5.3 released
Added the possibility to set the parameter values for a session; extracting grants, and many other improvements and bugfixes...
04/03/2013
EMS SQL Angel for SQL Server version 1.1 released
Added support of simultaneous backups on the same server, new features for managing templates and much more...
03/29/2013
EMS Advanced Query Builder updated
Embarcadero RAD Studio XE3 support added...

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 Maintenance Tools

SQL Angel
Save up to 95% of disk space and time while creating backups. Automate your database maintenance process to improve data availability and boost overall SQL Server performance. Create maintenance policies and monitor their real-time execution status.
SQL Administrator
Simplify and automate SQL Server administration process. Manage your maintenance tasks, analyze performance statistics, manage server permissions and find server security vulnerabilities.

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 20 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.

Components and Tools

Advanced Data Export VCL
Save your data from your VCL 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

04/03/2013
Facebook releasing new Social Graph database benchmark: LinkBench
Social network has released Linkbench, a database benchmark tailored for its social graph.
08/27/2012
Amazon adds features to Oracle cloud DB
Amazon Web Services has announced four new features for Amazon RDS for Oracle, including the ability to run the database in a private cloud.
06/04/2012
Oracle '12c' database set for December or January release
CEO Larry Ellison says it will be the first product Oracle won't port to Itanium chips
04/26/2012
Apache Delivers Version 1.1 of Cassandra NoSQL Database
The Apache Software Foundation announced the release of Cassandra 1.1, the latest version of the high-performance, open-source NoSQL database.

SQL Articles

Pavel Cisar and Paul Beach
The life cycle of a Firebird SQL statement
The article highlights the important aspects of the life cycle of a Firebird SQL statement.
Tamzin Oscroft
Oracle: Troubleshooting Internal Errors
By following the instructions in this article, you should be able to resolve some Oracle errors (ORA-600 and ORA-7445) that are caused by underlying physical issues such as file corruption or insufficient swap space.
Gregory A. Larsen
Finding the Source of Your SQL Server Database I/O
The article discusses the methods of measuring and identifying I/O related performance information for your SQL Server database instances.
Leo Hsu and Regina Obe
PostgreSQL Array: The ANY and Contains trick
Build-in PostgreSQL arrays support: using array elements as comma separated items in an SQL ANY clause and using arrays in column definitions and with Contains operator.