EMS logo

Products Navigation

choose your database tool

Our customers

Testimonials

Our company specializes in Database applications and technologies in general. We’ve found your products excellent in case of our client, utilizing MySQL database.
Athanasios Alekizoglou
Qualisys Information Technology System

Our Partnership Status

MySQL Gold Certified Partner
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

01/17/2012
EMS SQL Manager for MySQL version 5.2 released
Added the authorization type at MySql server, the support of index properties, and much more…
12/15/2011
Advanced Data Import VCL version 3.5 released
New properties added, the parsing logic of the Map property changed, and much more…
12/12/2011
EMS SQL Manager for PostgreSQL version 5.1 released
Added support of new PostgreSQL 9.1 features, a lot of improvements and bug-fixes...
12/08/2011
EMS DB Comparer for MySQL 4.0 released
Added the Project Management Wizard, significantly improved the algorithm of object comparison and script generation, and much more…
11/29/2011
EMS Data Import version 3.5 released
Added the possibility to rollback the transaction, if an error occurs, import in Excel 2007 improved, and much more…
10/07/2011
Advanced Excel Report version 1.9 released
Embarcadero RAD Studio XE2 support added...
10/07/2011
Advanced Localizer version 1.9 released
Embarcadero RAD Studio XE2 support added...
10/07/2011
Advanced Query Builder version 3.9 released
Embarcadero RAD Studio XE2 support added...
10/07/2011
Advanced PDF Generator version 1.5 released
Embarcadero RAD Studio XE2 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 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.

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

01/23/2012
Amazon launches scalable database service for apps
Amazon has launched DynamoDB, a fully-managed, cloud-based database service specifically built to adapt to the scaling issues of web applications and online games as their userbases and needs grow.
12/14/2011
Microsoft Announces SQL Azure Q4 Service Release Availability
In addition to announcing a series of changes performed to the Windows Azure website, complemented by the availability of new developer tools, Microsoft also announced the availability of the SQL Azure Q4 Service Release.
11/22/2011
MySQL 5.5.18 fixes replication issues
Oracle has released MySQL 5.5.18, the latest of the regular updates to the production version of the open source database.
10/31/2011
IBM to unveil NoSQL technology inside DB2
IBM plans to roll out NoSQL technology inside of its flagship DB2 database management system early next year.

SQL Articles

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.
Hazan Ilan
MySQL Left Join
The article discussing very helpful methods of using MySQL LEFT JOIN syntax. Even if you think you know everything about LEFT JOIN, you will learn something new in this article!
Steve Howard
Eliminating Deadlocks Caused By Foreign Keys with Large Transactions
Validating foreign keys requires additional work for data modification operations and can lead to deadlocks in certain scenarios. There are, however, ways you can work around this contention and eliminate the possibility of the deadlocks.