EMS logo

Products Navigation

choose your database tool

Our customers

Testimonials

I’m using SQL Manager for MySQL now and I think the SQL Manager is an absolutely useful program. I will post my congratulation to the developer team and I hope the team will go on to develop new programs in the future too. Then it will be grandiose.
Thomas Sebesta
Deutsche Speculativ-Fiction Daten Bank

Our Partnership Status

MySQL Gold Certified Partner
Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

Live Chat with Sales rep.

Sorry, Live Chat operators are offline now. Please, leave a message and we will get back to you ASAP.

News

04/27/2012
EMS SQL Manager for MySQL version 5.3 released
Added the possibility to update and edit procedures with limited rights, and other improvements and bug-fixes...
04/17/2012
SQL Manager for SQL Server version 3.8 released
Added support of new SQL Server 2012 features: sequences, custom server roles, columnstore indexes, FileTables, contained databases, and much more…
04/03/2012
Advanced Data Import VCL version 3.6 released
Added the “Functions” property to TQImportFieldFormat, and much more…
03/29/2012
SQL Query version 3.4 released
Added the possibility to save SSH connection settings, and other improvements and bug-fixes...
03/21/2012
EMS SQL Manager for Oracle version 3.0 released
New tools added: Database Compare and Instance Manager, HTML Report tool is enhanced, some other new features and improvements...
03/12/2012
EMS Data Comparer version 3.4 released
Added the possibility to export comparison results into MS Excel 2007, other improvements and bugfixes…
03/06/2012
Advanced Data Export VCL version 4.7 released
Added the Aggregates and TrimCaptionsToDataLength properties, and much more…
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…

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 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/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.
04/03/2012
IBM Releases DB2 Version 10, the First Big Upgrade in Four Years
IBM's newly updated flagship database can shrink storage requirements and speed query response, the company claims.
03/11/2012
Microsoft Readies SQL Server 2012 for April 1 Release
The biggest improvement is that it's been infused with a set of new features designed to handle larger workloads -- whether on premises or in the cloud.
02/17/2012
MySQL Cluster 7.2 adapted for large web providers by Oracle
Oracle has updated its MySQL Cluster software to make it more appealing to large web service providers, among other users of large-volume distributed databases.

SQL Articles

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