EMS SQL Management Studio for SQL Server 1.0.0.6

EMS SQL Management Studio for SQL Server is a complete solution for database administration and development EMS SQL Management Studio for SQL Server is a complete solution for database administration and development.
With components that focus on all critical database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering databases and managing database objects as well as for database migration, extraction, data import, export and comparison.
SQL Studio unites these utilities 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, SQL Studio for SQL Server offers all essential tools to make you more productive than ever before!
SQL Management Studio for SQL Server components:
- SQL Manager for SQL Server - 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.
- Data Export for SQL Server - Export your data to any of 15 most popular data formats, including MS Access, MS Excel, MS Word, PDF, HTML and more.
- Data Import for SQL Server - Import your data from MS Access, MS Excel and other popular formats to database tables via user-friendly wizard interface.
- Data Pump for SQL Server - Migrate from most popular databases (MySQL, PostgreSQL, Oracle, DB2, InterBase/Firebird, etñ.) to SQL Server.
- Data Generator for SQL Server - Generate test data for database testing purposes in a simple and direct way. Wide range of data generation parameters.
- DB Comparer for SQL Server - Compare and synchronize the structure of your databases. Move changes on your development database to production with ease.
- DB Extract for SQL Server - Create database backups in the form of SQL scripts, save your database structure and table data as a whole or partially.
- SQL Query for SQL Server - Analyze and retrieve your data, build your queries visually, work with query plans, build charts based on retrieved data quickly and more.
- Data Comparer for SQL Server - Compare and synchronize the contents of your databases. Automate your data migrations from development to production database.
Main features:
Basic features
- Support of SQL Server versions from 7.0 to 2005
- Simple management of database objects (including create/edit/drop operations)
- Easytowork integrated environment uniting all SQL Studio capabilities
DB registration and connection
- Multiple host/database connections
- Registering selected databases to work with
- Grouping/Ungrouping registered databases by host name
- Single repository for all DBs registered with EMS Software Development applications.
DB management
- Backup any registered database
- Restore previously backed up database
- Manage backup devices
- Configure linked servers
- Executing/importing/exporting DTS packages
- Creating/editing/dropping SQL Server jobs and viewing their history
- Creating/editing/dropping SQL Server alerts
- Creating/editing/dropping SQL Server operators
- Powerful login manager to administer server logins and their privileges
- Grant manager displaying all database object grants in the form of a grid
Data manipulation
- View, edit, search, group, sort, filter any data stored in registered database
- Export data in many formats (MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc.)
- Export data stored in different DBs in a single operation
- Import data from many sources (MS Excel, DBF, TXT, CSV, XML, MS Access)
- Import data from different sources to different DBs in a single operation
- Convert database structure and data from OLE DB/ODBC data sources
- Generate test data to several database tables at the same time
- Console versions for all data manipulation utilities
Data Analysis
- DB comparison and synchronization ability
- Data comparison and synchronization ability
- Console versions for all data analysis utilities
Template management
- Create new templates for SQL Studio utilities
- Edit existing templates for SQL Studio utilities
- User friendly template manager. Fast access to the needed template.
- Launch the utility for the selected template in one click
Scheduler
- Scheduled execution of DB service tasks (BackUp, Restore, etc.)
- Scheduled execution of data manipulation tasks (Import, Export, etc.)
- Scheduled execution of any external applications
- Creation and execution of complex tasks
- Storage of logs for executed tasks
- Flexible system of task execution results notifications (email, net send, Application Log)
Log management
- Storage of logs for applications run by Scheduler
- Ability to search, view, delete, export existing logs
Report designer
- New Create Report Wizard allows you to create simple reports in a few clicks
- Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree
Other tools
- Extracting metadata and data into text files or SQL script editor
- Extracting metadata and data from different DBs in a single operation
- Console version of Extract metadata tool
- Powerful print metadata module for creating customizable metadata reports
- HTML report generator to create a detailed HTML report about your database quickly
- SQL Monitor
- SQL Query
- Saving favourite queries
- Saving query history
- Ability to create diagrams based on queries
Visual Database Designer
- Two diagram notations (IDEF1x and IE)
- Reverse engineering
- Ability to create/edit/drop tables and table fields, visually set links between them
- Saving as image or printing database diagram
New state-of-the-art graphical user interface
- Office 11 and Windows XP visual schemes support
- Customizable toolbars for all program windows
- Fully customizable program interface
- Localizable program interface
- Keyboard templates
System requirements:
- 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
- 64 MB RAM or more; 128 MB or more recommended
- 140MB of available HD space for program installation
- Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution 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 SQL Server
Version restrictions:
- 30-day trial