What's new in SQL Manager 2008 for SQL Server?
- Several new tools for working with the server are added: Server Log Viewer, Activity Monitor, Shrink Database wizard, Check Database wizard, Indices management and Update statistics wizards, server roles management.
- Implemented support for a number of additional SQL Server capabilities.
Support of Unicode in SQL Editor, Query Builder, Grid View, Import/Export Data wizards.
- All wizards, including Import/Export Data wizards, Extract Database wizard, Backup/Restore Database wizards run in background mode now, allowing the user to continue working with the program.
- New advanced SQL Editor of the Visual Studio 2005 kind with Code Folding, UNICODE support, code completion, syntax highlight and other useful features.
- Enhanced Data Import Wizard - now data can be imported up to 10 times faster; also added support of the following source file formats: HTML, XML Document, Open Document Format (ODF), Open XML Format (MS Word 2007, MS Excel 2007).
- The Permissions tab is added to object editors, making it possible to grant privileges for objects to users and groups.
- DB Explorer is improved in several respects.
- Now it is possible to save frequently used queries within the Favorite Queries node of DB Explorer; Favorite Queries can be stored either locally in Windows Registry (in this case they are only available for local users), or in a special table of the database (therefore, the queries can be accessed by all database users).
- Enhanced Visual Database Designer: a new diagram object (Comment) is added; now there is a possibility to select the specification level for displaying objects (only object names, only fields); when doing Reverse Engineering you can select schemas to add their tables to the diagram.
- Improved Data Export Wizard: now it works faster; several output file formats are added: XML Document, Open Document Format (ODF), Open XML Format (MS Word 2007, MS Excel 2007).
- Advanced Table Editor: a possibility to view and edit table properties within a separate tab is added.
- The Find Option tool is added to the Options menu which allows easily find the necessary option by a word or phrase present in the option name among all program options forms.
- Enhanced reports management system.
- It is now possible to execute functions directly in the Function Editor window.
- Extract Database wizard: object dependencies are now handled correctly.
- Backup/Restore Database wizards: implemented support of several additional backup/restore parameters applied to SQL Server 2005 (copy-only backup, verify backup when finished, checksum support).
- Lots of other improvements and bug-fixes.
SQL Server 中 SQL Manager 2008 有哪些更新?
- 添加了多个与服务器一起运行的工具:Server Log Viewer, Activity Monitor, Shrink Database wizard, Check Database wizard, Indices 管理以及 Update 统计向导、服务器角色管理。
- 实现了对许多附加 SQL Server 功能的支持。
- 在 SQL Editor, Query Builder, Grid View, Import/Export Data 向导中支持 Unicode.
现在,所有向导,包括 Import/Export Data wizards, Extract Database wizard, Backup/Restore Database wizards, 都在后台运行,以允许用户继续执行程序。
- 新的高级的类似于 Visual Studio 2005 中的 SQL Editor, 具有 Code Folding, 支持 UNICODE, 代码完成、句子加亮、以及其它有用功能。
- 增强了的 Data Import Wizard – 现在,可以以比以前10被快的速度导入数据;而且添加了对以下源文件格式的支持:HTML, XML Document, Open Document Format (ODF), Open XML Format (MS Word 2007, MS Excel 2007).
- 对对象编辑器添加了 Permissions 标签,以使它能够对用户和组授予对象的权利。
- 在多个方面改进了 DB Explorer 的性能。
- 现在,在 DB Explorer 的 Favorite Queries 节点中,能够保存频繁的使用过的查询;可以在本地的 Windows Registry (在这种情况下,它们仅对本地用户可用)中,或者在数据库的特定表中(因此,所有数据库用户都可以访问查询),对 Favorite Queries 进行分类。
- 增强了 Visual Database Designer: 添加了一个新的图表对象 (Comment); 现在,可以选择特定的级别来显示对象(仅对象名、仅字段);当执行 Reverse Engineering 时,用户可以选择模式以给图表中添加表。
- 改善了 Data Export Wizard: 现在,它运行速度更快;添加了多个输出文件格式:XML Document, Open Document Format (ODF), Open XML Format (MS Word 2007, MS Excel 2007).
- 高级的 Table Editor:添加了在一个单独标签中查看以及编辑表属性的功能。
- 对 Options 菜单天际了 Find Option 工具,以在所有程序选项表格中,通过选项名中的单词或者短语快速查找必要的选项。
- 增强了报告管理系统。
- 现在,可以在 Function Editor window 中直接执行功能。
- Extract Database wizard:现在,可以正确处理对象依赖。
- Backup/Restore Database wizards:实现了对多个附加的应用到 SQL Server 2005 中的备份/还原参数的支持(仅拷贝备份,完成后执行验证备份,支持验证和)。
- 进行了大量的其它改进以及错误修复。