EMS SQL Management Studio for InterBase e Firebird

What is EMS SQL Management Studio for InterBase e Firebird?

EMS SQL Management Studio for InterBase and Firebird is a complete solution for managing and developing InterBase and Firebird databases. With components focused on all critical database management tasks, SQL Studio for InterBase and Firebird is a single desktop that provides essential tools for managing IB and Firebird databases, managing schemas and database objects, as well as for InterBase and Firebird database design,  migration, extraction, creation of InterBase and Firebird queries, data import, export and comparison of databases.

SQL Studio unites these database tools for InterBase and Firebird in a powerful, easy-to-use environment. With SQL Management Studio, many database administration objectives, such as data migration, loading, and synchronization, can be automated, backed up, and database extraction, allowing InterBase and Firebird database administrators and application developers to perform complex tasks regularly with minimal effort and a high level of flexibility. Whether you're a database or application developer, DBA, or business analyst, SQL Studio for InterBase and Firebird offer all the essential Tools of InterBase and Firebird to make you more productive than ever!

EMS SQL Management Studio components for InterBase /Firebird

SQL Manager for InterBase/Firebird - Simplify and automate your InterBase/Firebird database development process, design, explore and maintain existing InterBase/Firebird databases, create SQL InterBase/Firebird query composite statements, manage SQL InterBase/Firebird user rights, manage InterBase/Firebird database user rights, and manipulate data in different ways.

Data Export to InterBase/Firebird - Export data from the InterBase/Firebird database to any of the 20 most popular data formats, including MS Access, MS Excel, MS Word, PDF, HTML, ODF, and more.

Data import to InterBase/Firebird - Import data to MS Access, MS Excel, CSV, XML, and other popular database tables through the friendly wizard interface.

Data Pump for InterBase/Firebird - Migrate from the most popular databases (MS SQL Server, MySQL, PostgreSQL, Oracle, DB2, etc.) to InterBase / Firebird. Convert the schema from the database and import the table data into the InterBase/Firebird database from any ADO-compliant source.

Data Generator for InterBase/Firebird - Generate test data for the InterBase/Firebird database for testing purposes in a simple and straightforward manner. Wide range of data generation parameters, user-friendly interface and useful console utility to automate the generation of test data from InterBase / Firebird.

Database Comparator for InterBase/Firebird - Compare and synchronize the structure of the InterBase/Firebird databases. Move changes in your development database to production with ease.

Database Extract for InterBase/Firebird - Create InterBase/Firebird database backups in the form of SQL scripts, script and save the interbase/firebird database structure and table data as a whole or partially.

SQL Query for InterBase/Firebird - Analyze and retrieve your data, visually build your InterBase/Firebird queries, work with InterBase/Firebird query plans, build charts based on quickly retrieved data, and more.

Data Comparator for InterBase/Firebird - Compare and sync the contents of your InterBase/Firebird databases. Automate your data migrations from development to production database. Customize the InterBase/Firebird comparison and synchronization process to meet your needs.

Additional SQL Studio features

• Practical release of utilities and services.
• Storing all models in a single repository.
• List of common data sources for all services and utilities.
• Creating complicated tasks and performing scheduled tasks.
• Ability to run external applications from the calendar.
• Storing all task execution logs in a database.
• Creating custom notifications with a variety of delivery options.
• Ability to define the visual interface style exclusively for all SQL Studio applications.
• Quick access to EMS Technical Support Service.

System requirements

• 300 MHz processor; Recommended 600 MHz (MHz) processor
• Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows Vista x64, Microsoft Windows 7, Microsoft Windows 7 x64
• 64 MB of RAM or more; 128 MB or more recommended
• 140 MB of available HD space for program installation
• Super VGA (800x600) or higher resolution video adapter and monitor; Super VGA (1024x768) or higher resolution video adapter and monitor is recommended
• Microsoft mouse or compatible pointing device
• Microsoft Data Access Components (MDAC) or SQL Server Native Client
• Possibility to connect to any local or remote InterBase/Firebird Server