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

01/29/2010
SQL Manager for Oracle version 2.4 released
Added the ability to connect though TNS_ADMIN, new events for monitoring are added, and much more…
12/25/2009
Advanced Data Export version 4.2 released
RAD Studio 2010 support added, Portuguese Brazilian, Turkish, Spanish and Dutch localizations added, and much more…
12/16/2009
EMS SQL Manager for DB2 version 1.4 released
Added Ping Database wizard; new objects, privileges, user types added; the RUNSTATS service improved, and much more…
12/15/2009
Advanced Data Import VCL version 3.2 released
RAD Studio 2010 support, the Italian localization added, and much more…
12/03/2009
EMS Data Import version 3.3 released
Added the possibility to choose encodings, the support of date formats expanded, some visual changes, and much more…
11/10/2009
SQL Manager for SQL Server version 3.5 released
Added the possibility to extract system objects, a lot of different improvements and enhancements…
10/09/2009
DB Comparer version 3.3 released
Firebird 2.1 and Unicode support added, the possibility to compare FEDERATED tables added, and much more...
09/10/2009
SQL Manager for PostgreSQL version 4.6 released
Support of new PostgreSQL 8.4 features, support of new values in the Data View and new statements in the Function Debugger, a lot of other improvements…
08/27/2009
Advanced PDF Generator version 1.2 released
BDS 2009 support added...
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 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/20/2010
Microsoft Readies SQL Server 2008 R2 for May Release
Microsoft plans to release SQL Server 2008 R2, currently in the CTP phase, by May 2010.
01/10/2010
Oracle set to release 24-fix update
New patch will deal with database and application server vulnerabilities.
12/16/2009
MySQL 5.5 Milestone 2 improves replication and stored procedures
The MySQL developers have released milestone 2 of MySQL 5.5, on the path to a general release in mid-2010.
12/01/2009
IBM Confirms Acquisition of Database Security Vendor
After initially refusing to comment, IBM gives in and confirms reports that it is acquiring Guardium. The acquisition brings Guardium's database activity monitoring and data security capabilities into IBM's software portfolio.
News Subscribe | More News | XML content. Requires RSS support to view.

SQL Articles

Adriano dos Santos Fernandes
Window Functions in Firebird 3
One of the Firebird Core Developers has published some information about the implementation of the OVER function in Firebird 3.
Roland Bouman
Validating MySQL data entry with triggers: A quick look at the SIGNAL syntax
MySQL 5.5 New Features: support for an ANSI/ISO standard SIGNAL syntax.
Dirk Fechner, IT Services Specialist, IBM
How to identify unused indexes in DB2 for Linux, UNIX, and Windows
Get to know different approaches for determining indexes never or rarely used by database queries.
Brian Egler
Replicate down or up-level - your choice
The article discusses the replication with different versions of SQL Server.
News Subscribe | More Articles | XML content. Requires RSS support to view.

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