All September Get EMS SQL Tools at the best price
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)

News

09/01/2010
EMS September Offerings for Software and Maintenance purchase

Check out a rich palette of falling prices at EMS! 15% OFF all EMS software till the end of September!

08/26/2010
SQL Manager for MySQL version 4.6 released
New features added: the possibility to view geometry fields in the BLOB Editor, to grant CREATE TRIGGER and DROP TRIGGER rights, and much more…
08/24/2010
EMS Data Import version 3.4 released
Support of Microsoft Office Access 2007 files and complicated date templates added, and more improvements and fixes…
08/03/2010
SQL Manager for Oracle version 2.5 released
Added TKProf Wizard, Queue and Queue Table objects, the possibility to schedule backup process appeared, and much more…
06/23/2010
SQL Manager for SQL Server version 3.6 released
A great number of improvements and enhancements...
05/06/2010
EMS Data Comparer version 3.0 released
Added the Commit after synchronization option, added the possibility to generate summary reports, to sort and filter comparison results, and much more…
04/07/2010
All EMS SQL tools are now Windows 7 compatible
Now all SQL tools developed by EMS officially support Windows 7
02/18/2010
EMS SQL Manager for PostgreSQL version 4.7 released
Added the support of column level privileges and Truncate privilege, the Refresh Rate is now saved between sessions, many small improvements and much more…
02/18/2010
EMS Data Export version 3.3 released
Some visual changes are introduced, decimal fields are exported properly, and much more...

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

09/02/2010
PostgreSQL 9.0's first release candidate arrives
The first release candidate for version 9.0 of the PostgreSQL open source database has been released after four months in beta.
08/18/2010
Cumulative Updates Available for SQL Server 2008 R2, 2008 SP1 and 2005 SP3
Customers running the latest versions of Microsoft’s data platform have a range of update packages available from the company.
07/14/2010
Oracle Patches 59 Vulnerabilities
Sun Solaris product suite, Oracle Database Server, Fusion Middleware, and Supply Chain Products Suite vulnerable to remote exploitation, with no authentication required.
07/05/2010
Microsoft links free SQL database with ASP .Net
Allowing SQL CE Version 4 to work with ASP.Net Web apps gives developers a lightweight database option.

SQL Articles

Adriano dos Santos Fernandes
Window Functions in Firebird 3 (part2) - cumulative aggregates
Another article about the specifics of using the window functions support in Firebird 3.
Andrew Morgan
Replacing MEMORY storage engine with MySQL Cluster
The article discusses using MySQL Cluster as an alternative to the MySQL MEMORY storage engine.
Leo Hsu and Regina Obe
Encrypting PostgreSQL data with pgcrypto
In this article we'll go over the basics built-in and the more advanced provided by the PostgreSQL contrib module pgcrypto.
Larry Alston
A Practical Guide to Adopting an Open Source Database for Enterprise IT Use
Trends & Applications: The article discusses the drivers and benefits of using open source database management systems in the enterprise.

Products Navigation

choose your database tool

Our customers

Testimonials

I bought your SQL Manager for PostgreSQL product; I've gotta tell you it is superb! Without this tool, I don't think I could have used the PostgreSQL database. Upon reviewing your other products, I see that your SQL Manager for MySQL looks great! I love what I see in the screenshots. I'm really looking forward to seeing you create a wider product line. I'd gladly purchase your next version in order to help you continue to create such an awesome product. You've done wonders for the open source database communities at large and I would be a crippled developer without this fine tool. Thanks, and keep up the great work!
D. Dante Lorenso

Our Partnership Status

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