Products Navigation
choose your database tool
- choose your database tool
- SQL Studio
- SQL Studio for MySQL
- SQL Studio for PostgreSQL
- SQL Studio for SQL Server
- SQL Studio for IB/FB
- SQL Studio for Oracle
- MySQL Tools
- SQL Studio for MySQL
- SQL Manager for MySQL
- Data Export for MySQL
- Data Import for MySQL
- Data Pump for MySQL
- Data Generator for MySQL
- Data Comparer for MySQL
- DB Comparer for MySQL
- DB Extract for MySQL
- SQL Query for MySQL
- SQL Server Tools
- SQL Studio for SQL Server
- SQL Manager for SQL Server
- Data Export for SQL Server
- Data Import for SQL Server
- Data Pump for SQL Server
- Data Generator for SQL Server
- Data Comparer for SQL Server
- DB Comparer for SQL Server
- DB Extract for SQL Server
- SQL Query for SQL Server
- PostgreSQL Tools
- SQL Studio for PostgreSQL
- SQL Manager for PostgreSQL
- Data Export for PostgreSQL
- Data Import for PostgreSQL
- Data Pump for PostgreSQL
- Data Generator for PostgreSQL
- Data Comparer for PostgreSQL
- DB Comparer for PostgreSQL
- DB Extract for PostgreSQL
- SQL Query for PostgreSQL
- InterBase / Firebird SQL Tools
- SQL Studio for IB/FB
- SQL Manager for IB/FB
- Data Export for IB/FB
- Data Import for IB/FB
- Data Pump for IB/FB
- Data Generator for IB/FB
- Data Comparer for IB/FB
- DB Comparer for IB/FB
- DB Extract for IB/FB
- SQL Query for IB/FB
- Oracle Tools
- SQL Studio for Oracle
- SQL Manager for Oracle
- Data Export for Oracle
- Data Import for Oracle
- Data Pump for Oracle
- Data Generator for Oracle
- Data Comparer for Oracle
- DB Comparer for Oracle
- DB Extract for Oracle
- SQL Query for Oracle
- DB2 SQL Tools
- SQL Manager for DB2
- Data Export for DB2
- Data Import for DB2
- Data Pump for DB2
- SQL Query for DB2
- Data Generator for DB2
- DB Extract for DB2
- Tools&Components
- Advanced Data Export VCL
- Advanced Data Export .NET
- Advanced Data Import VCL
- Advanced PDF Generator
- Advanced Query Builder
- Advanced Excel Report
- Advanced Localizer
- Source Rescuer
Testimonials
When we changed our DBMS to PostgreSQL a couple of years ago, I tried many DB-clients, before I found SQLManager. The ease of use of SQLManager is impressive! The clear and well structured GUI makes the daily work done easy. In addition EMS' customer support is just fabulous! Further on: Good speed!
Markus Reidt
Nordmann, Rassmann GmbH, Hamburg
Nordmann, Rassmann GmbH, Hamburg
Our Partnership Status
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
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…
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…
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...
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…
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…
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…
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!
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 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.
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.
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.
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.
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.
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.
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!
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.
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.
© 1999-2012 EMS Database Management Solutions, Inc. All rights reserved.