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.

Velaro Live Help | Learn More

News

10/16/2008
DB Extract version 3.0 released
Unicode support is added, support of the latest server versions, the extraction speed considerably increased, program interface improved, many other improvements and bug-fixes...
10/15/2008
DB Comparer version 3.2 released
PostgreSQL 8.3 support added, Database comparison speed considerably increased, some more fixes and improvements…
10/08/2008
SQL Manager for Oracle 2.1 released
Added the Flashback wizard, search in metadata is implemented, a lot of improvements and bugfixes…
10/08/2008
SQL Query version 3.2 released
Unicode data support added, visual building of the FROM statement subqueries is now possible, and other improvements and fixes…
10/02/2008
Data Comparer version 2.2 released
Added support of PostgreSQL 8.3, support of Unicode data for InterBase, new enhanced Script Editor, the script generation mechanism is optimized, and many other improvements and bug-fixes…
09/30/2008
SQL Manager for SQL Server version 3.3 released
Added support of compressed tables and indexes, field and file group filestreams, filtered indexes, a lot of improvements and bug-fixes…
09/24/2008
SQL Manager for DB2 version 1.2 released
New data manipulation services and support of new objects are added, new tablespace and indices options are available, a lot of interface improvements and different bugfixes…
09/17/2008
SQL Manager for InterBase/Firebird version 5.1 released
Preliminary support of Firebird 2.5, the ability to create external and global temporary tables added, the ability to save object templates, fixed errors occurred during the script execution and much more…
09/11/2008
Advanced Excel Report 1.6 released
Borland Delphi 2009 is supported now
News Subscribe | More News

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.
Data Generator
Generate test data for database testing purposes in a simple and direct way. Wide range of data generation parameters.

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 Export .NET
Fast write data to MS Excel, MS Word, Open XML Format, Open Document Format (ODF), HTML, XML, PDF, CSV and more from your .NET applications
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/19/2008
Sun: MySQL 5.1 Open-Source Database GA Near
Officials at Sun say the MySQL 5.1 open-source database will be generally available in the coming weeks. Sun had said MySQL 5.1 would be available earlier in 2008, but had to delay the release to allow developers to fix bugs.
08/13/2008
Microsoft Releases SQL Server 2008
Customers and partners worldwide confirm mission-critical applications, enterprise-class data warehousing support.
02/05/2008
PostgreSQL 8.3 released
The PostgreSQL Global Development Group today announced the release of version 8.3 of the high-performance object-relational database management system...
01/17/2008
Oracle has released its first critical patch update of 2008 with 26 new security fixes
Oracle has released its first critical patch update of 2008 with 26 new security fixes.
News Subscribe | More News | XML content. Requires RSS support to view.

SQL Articles

Brian Prince
Open-Source Databases MySQL, PostgreSQL, Adoption Rising
Open-source databases MySQL and PostgreSQL are gaining steam, but rip-and-replace situations where MySQL and PostgreSQL replace Oracle Database, IBM DB2 or Microsoft SQL Server databases remain rare.
rdoherty
SQL Server 2008 Top 10 List for Developers
My boss, Mauricio, has been on me for months asking me to list the top 10 features of SQL Server 2008. I have been stalling. I think every single feature in the product is compelling, and inevitably I am going to leave something out and will hear about it
Randy Dyess
SQL Server 2008 released
Once again, Microsoft has released a new version of SQL Server that promises to improve life for database administrators. The latest version is SQL Server 2008, and it offers a large variety of new features and functionality that will make the administrat
MySQL AB
MySQL 5.1 partitions in practice
This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions.
News Subscribe | More Articles | XML content. Requires RSS support to view.

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

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