Hot summer, cool prices, best deals at EMS!
EMS logo

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

06/30/2009
EMS Summer offerings - extended till July 15!
Check out our summer deals! 20% OFF all EMS software till the July 15!
06/22/2009
SQL Manager for MySQL version 4.5 released
Support of Windows 7, added the possibility to search in metadata, and much more…
06/09/2009
SQL Manager for DB2 version 1.3 released
Added the console for executing server commands, SQL Parser and DB extraction process improved, added the possibility to duplicate security objects, and much more…
05/26/2009
SQL Manager for SQL Server version 3.4 released
Added support of Resource Governor, 'FOR XML' clause in queries, using macro is now possible in SQL Editor and SQL Script, a lot of improvements and bug-fixes...
03/11/2009
Data Comparer version 2.3 released
Added the Commit after synchronization option, added the possibility to generate summary reports, to sort and filter comparison results, and much more…
03/02/2009
EMS Data Export version 3.2 released
Support of PostgreSQL 8.3 and SQL Server 2008 added, export in MS Word 2007 improved, and much more…
02/24/2009
EMS Data Pump version 3.0 released
Unicode support implemented, support of the latest DBMS versions, password encryption and much more…
02/04/2009
EMS Data Import version 3.2 released
SQL Server 2008 and PostgreSQL 8.3 support added, the possibility to create tables for imported data, and much more…
01/19/2009
Advanced Localizer version 1.6 released
BDS 2009 support added...

EMS SQL Management Studio TM

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!

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

06/15/2009
PostgreSQL 8.4 Release Candidate 1 Now Available
The next version of PostgreSQL is now available for final pre-release testing.
06/01/2009
Oracle Releases Oracle Warehouse Management
Oracle releases Oracle Warehouse Management, a modular application that can now be operated by businesses and the enterprise without upgrading to Oracle E-Business Suite.
05/18/2009
MySQL Founder Launch the Open Database Alliance
The "Open Database Allaince" was announced with plans to bring together the MySQL community
05/06/2009
Microsoft Seeking Cloud Database Customers to Test Project Huron
Microsoft is welcoming early adopters to Project Huron, part of its cloud-based push. The goal of Project Huron is to allow users to synchronize local copies of a database with a database in the cloud.

SQL Articles

Susan Harkins, TechRepublic
10+ tips for working smarter with SQL
Whether you use SQL a lot or sparingly, working smarter with SQL will help you avoid errors and improve performance.
Brian Egler
Get rid of those NOLOCK hints
This article discusses the use of various techniques to reduce the negative impact of the data locking issues.
Andrew J. Kelly
Focus on Files and Filegroups
Don’t create too many files in your database in an effort to improve performance
Sean Hull
Optimizing the MySQL Query Cache
Keeping MySQL's query cache optimized and used efficiently can make a big difference in the overall throughput of your application.

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 Gold Certified Partner
Oracle Certified Partner
Borland Technology Partner
CodeGear - Where Developers Matter