What is EMS SQL Management Studio for SQL Server?
EMS SQL Management Studio for SQL Server is a complete solution for administering and developing Microsoft SQL Server databases. With components focused on all critical MS SQL Server database management tasks, SQL Studio is a single desktop that provides essential tools for managing SQL Server databases, managing the schema and database objects, as well as for design, migration, extraction, sql server query creation, data import, export, and database comparison.
SQL Studio unites these database tools for SQL Server in a powerful, easy-to-use environment that can work 24 hours a day. With SQL Management Studio, many database administration objectives, such as data migration, loading, and synchronization, can be automated, backed up, and database extraction, enabling SQL Server database administrators and SQL Server 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 SQL Server offers all the essential SQL Server tools to make you more productive than ever before!
Componentes do SQL Management Studio for SQL Server
- SQL Manager for SQL Server - Simplify and automate the Microsoft SQL Server database development process, design, explore, and maintain existing MS SQL Server databases, create sql server composite query statements, manage sql server database user rights, and manipulate data in different ways.
- Data Export to SQL Server - Export data from the SQL Server 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 SQL Server - Import data to SQL Server database tables from MS Access, MS Excel, CSV, XML, and other popular formats through the user-friendly wizard interface.
- Data Pump for SQL Server - Migrate from the most popular databases (MySQL, PostgreSQL, Oracle, DB2, InterBase / Firebird, etc.) to SQL Server. Convert the schema from the database and import the data from the table into the SQL Server database from any ADO-compliant source.
- Data Generator for SQL Server - Generate test data for the SQL Server database for testing purposes in a simple and straightforward manner. Wide variety of data generation parameters, wizard-friendly interface, and useful console utility to automate SQL Server test data generation.
- Database comparator for SQL Server - Compare and synchronize the structure of SQL Server databases. Move changes in your development database to production with ease.
- Database extraction for SQL Server - Create SQL Server database backups in the form of SQL scripts, script, and save the sql server database structure and table data as a whole or partially.
- SQL Query for SQL Server - Analyze and retrieve your data, visually create your SQL Server queries, work with SQL Server query plans, create charts based on quickly retrieved data, and more.
- Data Comparator for SQL Server - Compare and synchronize the contents of SQL Server databases. Automate your data migrations from development to production database. Customize the MS SQL Server 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 schedule.
- 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 com SP4 ou posterior, 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
- MDAC (Microsoft Data Access Components) ou SQL Server Native Client
- Possibility to connect to any local or remote SQL Server
