Main > Network & Internet > Database Utils >

EMS SQL Manager for SQL Server Freeware 3.4



 

EMS SQL Manager for SQL Server Freeware 3.4

Sponsored Links

EMS SQL Manager for SQL Server Freeware 3.4 Ranking & Summary

RankingClick at the star to rank
Ranking Level
Buy now
User Review: 0 (0 times)
File size: 53.88 MB
Platform: WinNT 4.x,WinXP,Windows2000,Windows2003,Windo
License: Freeware
Price: $0.00
Downloads: 67
Date added: 2009-06-03

EMS SQL Manager for SQL Server Freeware 3.4 description

Manager for SQL Server Freeware 3.4 is a graphical tool for Microsoft SQL Server database development and administration, which includes tools required by users new to SQL Server and only need its basic functionality. As a light edition, SQL Manager Freeware has certain restrictions, for example, it can handle not more than 5 databases, and some others.

SQL Manager works with any MS SQL Server versions from 7 to the newest one and supports the latest SQL Server features including new data types (datetimeoffset, hierarchyid, geometry, geography and more), table types and table-valued parameters, logon triggers, backups with compression and other. It offers plenty of powerful SQL tools such as Visual Database Designer that allows creating SQL Server database in few clicks, Visual Query Builder and advanced SQL editor to build complicated SQL Server queries and many more useful features for efficient SQL Server administration. SQL Manager for SQL Server has a state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
Major Features:

  1. Support of SQL Server 2008
    • Support of new data types: date, datetime2, datetimeoffset, time, hierarchyid, geometry, geography
    • Support of table types
    • Support of logon triggers
    • Supports of new backup parameters: compression, buffer count, max transfer size
    • Support of Unicode data
  2. Rapid database management and navigation
    • Multiple host/database connections
    • Database properties management
    • Server properties management
    • Registering databases for working with the required databases only
    • Projects to work with the selected database objects only
    • Multiple user-defined tabs for any tree node to access it in one-click.
    • Working with multiple selected objects at a time
    • Grouping/ungrouping registered databases by host name
  3. Easy management of all SQL Server objects
    • Creating/dropping databases and schemas
    • Managing tables and all their subobjects: fields, indices, triggers, checks and foreign keys
    • Managing views, procedures and user-defined functions
    • Managing user-defined types, synonyms, DDL triggers, assemblies, aggregates, XML schema collections, defaults and rules
    • Managing partition functions and schemes, full-text catalogs and indices, symmetric and asymmetric keys, certificates
    • Managing jobs, schedules, alerts, operators, endpoints, linked servers, credentials, proxies
    • Duplicating all database objects
    • Viewing dependencies between database objects
  4. Advanced data manipulation tools
    • Powerful BLOB viewer/editor with several types of viewing BLOB data
    • Plenty of useful tools such as data grouping, summarizing, fast searching and filtering
    • Master-detail view to work with two linked tables at the same time
    • Table and card views to see data the way you like
    • Support of queries returning multiple result sets
    • Ability to copy and paste selected records
    • Advanced printing system
  5. Effective security management
    • Powerful login manager for administering server logins
    • Managing database users and user-defined roles
    • Managing server roles membership
    • Grant manager displaying all database object grants in the form of a grid
    • Viewing and changing object permissions to database roles in object editors
  6. Excellent visual and text tools for query building
    • Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax
    • Multiple SQL editors with code completion, syntax highlight and code folding
    • Large script executing (SQL script editor)
    • Ability to view actual and estimated query plan as diagram
    • SQL Formatter (Available from SQL Editor context menu)
    • Favorite Queries (Save and use your frequently used queries easily)
  7. Impressive data export and import capabilities
    • Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc.
    • Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV
    • Bulk Insert wizard
    • Exporting data to SQL script as INSERT statement with selecting destination DBMS
  8. Visual Database Designer to handle database structure in a few clicks
    • Creating diagram of existing database using Reverse engineering tool
    • Dividing diagram into different subject areas located on separate pages
    • Navigating through diagram using preview navigation to
    • Creating/editing/dropping tables and table fields, visually setting links between them
    • Ability to add comments to diagram
    • Saving as image or printing database diagram
    • Two diagram notations (IDEF1x and IE)
    • A lot of visual customization options
  9. Easy-to-use wizards performing SQL Server administrative tasks
    • Backing up database
    • Restoring database
    • Attaching database
    • Detaching database
    • Shrinking database
    • Managing indices
    • Updating statistics
    • Checking database
  10. Powerful tools to make your work with SQL Server as easy as it can be
    • Extracting metadata into text files or SQL script editor
    • Powerful print metadata module for creating customizable metadata reports
    • HTML report generator to create a detailed HTML report about your database quickly
    • Managing backup devices
    • Managing database snapshots
    • Viewing SQL Server logs
    • Monitoring SQL Server activity
  11. Report designer with clear in use report construction wizard
    • 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
  12. New state-of-the-art graphical user interface
    • Office 11 and Windows XP visual schemes support
    • Well-described Wizard System
    • Improved database explorer for easy management of all SQL Server objects
    • MDI and floating-window styles implementation
    • Windows Toolbar to switch between windows easily, like in Windows Task Bar
    • Navigation bars with hot actions in most of the windows
    • Ability to save all program settings
    • Customizable toolbars for all program windows
    • Fully customizable program interface
    • Powerful visual options module
    • Localizable program interface
  13. And other useful features
    • Keyboard templates
    • To-do list
    • External tool manager

Enhancements:

  1. The following SQL Server 2008 feature is now supported:
    • Resource Governor.
  2. Support of 'FOR XML' clause in queries used to return results as XML instead of standard rowsets.
  3. Using macro is now possible in SQL Editor and SQL Script.
  4. Data View | Blob View: the XML tab has been added allowing to view XML data as a tree.
  5. The Unicode support is implemented in procedure/function bodies, views, triggers, check constraints, object description, field default values and in a number of other object properties.
  6. Grant Manager:
    • Support of database permissions for SQL Server 2005 and higher has been added.
    • Users and roles are now separated in the 'Privileges for' list.
    • Column permissions were not always displayed correctly: the higher-level object permissions were not considered. Fixed now. 
  7. Database Registration Info:
    • Most of the options from the Grid | Data Options section of the Environment Options dialog can now be specified individually for each of the registered databases in the Database Registration Info dialog. The values specified on the Grid | Data Options page will be applied as default settings for newly registered databases.
    • A possibility to select the OLE DB Provider: OLE DB Provider for SQL Server or SQL Native Client has been added.
    • Metadata and SQL Editor logs can now be saved in UNICODE or ANSI.
  8. SQL Editor:
    • After the USE Transact-SQL statement execution the name of the current database is displayed in the status bar area of the editor.
    • Several errors concerning syntax highlight have been fixed.
    • Several bugs concerning incorrect parsing of table aliases in queries have been fixed.
    • The Ctrl+Alt+C shortcut did not work for showing the list of fields of the table whose name was copied to clipboard. Fixed now.
    • The displayed number of affected records was not always correct. Fixed now.
  9. DB Explorer:
    • The Find Object dialog has been improved.
    • The possibility to execute procedures and user-defined functions directly from DB Explorer (through the context menu) has been added.
    • The program now saves the information about the last opened database before shutdown. When the application is started next time, this database will be automatically selected in the DB Explorer tree.
    • The button for switching search mode has been added to the Search Panel toolbar.
    • Double-clicking an object group node folds and unfolds its branch.
    • When adding a server object, only this new object was displayed in the tree if the branch had not been refreshed yet. Fixed now.
  10. Extract Database:
    • Now the script is directly generated in the selected charset, which reduces the script generation time.
    • With the 'Generate DROP statements' option enabled, odd statements for deleting table subobjects were generated. Fixed now.
  11. Export as SQL Script: now the script is directly generated in the selected charset, which reduces the script generation time.
  12. Visual Database Designer:
    • Tables are arranged more compactly in the reverse engineering mode.
    • Alignment options did not work when a diagram was loaded from a file. Fixed now.
  13. Options: the ability to apply default settings (to all or just to a separate category of options) has been implemented for all option dialogs.
  14. Windows List: the 'Close All Database Windows' command has been implemented.
  15. Data Grid: the method of work in asynchronous mode is changed - the usage of a separate connection for each Data Grid makes it possible to perform simultaneous fetching without losing the ability to use other functions of the program.
  16. Data Grid: the selected data record highlight changes when the focus is switched from the grid.
  17. Job Step Editor: support of the 'Write log to table' option and new subsystems of SQL Server 2008 have been added.
  18. Changes that take place upon table recreation are now written to the log of metadata changes: changing column identity, reordering columns.
  19. Save Settings wizard: now, when saving settings to an existing file, the program suggests overwriting the file or making the new file unique by adding the current date and time to the file name.
  20. Environment Options | Tools | SQL Server Reference: an option for SQL Server 2008 Books Online has been added.
  21. Full-Text Catalog Editor:
    • The data type value of a full-text index was not applied on saving the object. Fixed now.
    • When saving changes, pressing Cancel in the Changing Metadata window resulted in losing changes in the editor. Fixed now.
  22. The DDL of user-defined functions did not contain field comments of the returned table. Fixed now.
  23. Linked Servers: the content of the linked server was not displayed by the application if the provider did not support the information in the catalog. Fixed now.
  24. Partition Function Editor: milliseconds in threshold values of datetime type were not displayed. Fixed now.
  25. Export Data: when exporting data of type decimal with precision less than 15 digits, the numbers were rounded to the 4th decimal digit. Fixed now.
  26. Query Builder: the width of the Link Properties dialog was set incorrectly when running in Windows Vista. Fixed now.
  27. It was impossible to change object description if the object's description was an empty string. Fixed now.
  28. Role Editor: the 'Refresh' command did not work within the Member of tab. Fixed now.
  29. Field Editor: the 'Sparse' option could not be disabled for NOT NULL fields (in SQL Server 2008).
  30. It was impossible to turn off the database compatibility level warning on connection - the 'Do not ask me again' option value was not saved after closing the program.
  31. Other minor improvements and bug-fixes.

Requirements:

  • 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
  • Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
  • 64 MB RAM or more; 128 MB or more recommended
  • 50MB 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
  • Local or remote SQL Server 7, SQL Server 2000, MSDE, SQL Server 2005 (It does not support SQL Server 2005 Compact Edition)
  • Supported MS SQL Server versions: from 7.0 up to 2008
WareSeeker Editor

EMS SQL Manager for SQL Server Freeware 3.4 Screenshot

EMS SQL Manager for SQL Server Freeware 3.4 Keywords

Bookmark EMS SQL Manager for SQL Server Freeware 3.4

Hyperlink code:
Link for forum:

EMS SQL Manager for SQL Server Freeware 3.4 Copyright

WareSeeker.com do not provide cracks, serial numbers etc for EMS SQL Manager for SQL Server Freeware 3.4. Any sharing links from rapidshare.com, yousendit.com or megaupload.com are also prohibited.

Allok Video Splitter 2.2.0 Review:

Name (Required)
Email(Required)
Captcha
Featured Software

Want to place your software product here?
Please contact us for consideration.

Contact WareSeeker.com
Related Software
EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features. Free Download
EMS SQL Manager Lite for MySQL is an excellent freeware graphical tool for MySQL Server administration. It has minimal required set of instruments for those users who are new to MySQL server and need only its basic functionality. Free Download
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. Free Download
EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development Free Download
EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development Free Download
EMS SQL Manager Lite for PostgreSQL is a light and easy-to-use freeware graphical tool for PostgreSQL administration. It has minimal required set of instruments for those users who are new to PostgreSQL server and need only its basic functionality. Free Download
EMS SQL Manager for DB2 is a high performance tool for DB2 Database Server administration and development. SQL Manager for DB2 works with DB2 versions 8.1 and 8.2 and supports all DB2 objects and data types. Free Download
Easy-to-use freeware graphical tool for MS SQL/MSDE administration Free Download