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 有哪些更新？

• 添加了多個與服務(wù)器一起運(yùn)行的工具：Server Log Viewer, Activity Monitor, Shrink Database wizard, Check Database wizard, Indices 管理以及 Update 統(tǒng)計向?qū)А⒎?wù)器角色管理。
• 實現(xiàn)了對許多附加 SQL Server 功能的支持。
• 在 SQL Editor, Query Builder, Grid View, Import/Export Data 向?qū)е兄С?Unicode.
  現(xiàn)在，所有向?qū)В?Import/Export Data wizards, Extract Database wizard, Backup/Restore Database wizards, 都在后臺運(yùn)行，以允許用戶繼續(xù)執(zhí)行程序。
• 新的高級的類似于 Visual Studio 2005 中的 SQL Editor, 具有 Code Folding, 支持 UNICODE, 代碼完成、句子加亮、以及其它有用功能。
• 增強(qiáng)了的 Data Import Wizard – 現(xiàn)在，可以以比以前10被快的速度導(dǎo)入數(shù)據(jù)；而且添加了對以下源文件格式的支持：HTML, XML Document, Open Document Format (ODF), Open XML Format (MS Word 2007, MS Excel 2007).
• 對對象編輯器添加了 Permissions 標(biāo)簽，以使它能夠?qū)τ脩艉徒M授予對象的權(quán)利。
• 在多個方面改進(jìn)了 DB Explorer 的性能。
• 現(xiàn)在，在 DB Explorer 的 Favorite Queries 節(jié)點(diǎn)中，能夠保存頻繁的使用過的查詢；可以在本地的 Windows Registry （在這種情況下，它們僅對本地用戶可用）中，或者在數(shù)據(jù)庫的特定表中（因此，所有數(shù)據(jù)庫用戶都可以訪問查詢），對 Favorite Queries 進(jìn)行分類。
• 增強(qiáng)了 Visual Database Designer: 添加了一個新的圖表對象 (Comment); 現(xiàn)在，可以選擇特定的級別來顯示對象（僅對象名、僅字段）；當(dāng)執(zhí)行 Reverse Engineering 時，用戶可以選擇模式以給圖表中添加表。
• 改善了 Data Export Wizard: 現(xiàn)在，它運(yùn)行速度更快；添加了多個輸出文件格式：XML Document, Open Document Format (ODF), Open XML Format (MS Word 2007, MS Excel 2007).
• 高級的 Table Editor:添加了在一個單獨(dú)標(biāo)簽中查看以及編輯表屬性的功能。
• 對 Options 菜單天際了 Find Option 工具，以在所有程序選項表格中，通過選項名中的單詞或者短語快速查找必要的選項。
• 增強(qiáng)了報告管理系統(tǒng)。
• 現(xiàn)在，可以在 Function Editor window 中直接執(zhí)行功能。
• Extract Database wizard:現(xiàn)在，可以正確處理對象依賴。
• Backup/Restore Database wizards:實現(xiàn)了對多個附加的應(yīng)用到 SQL Server 2005 中的備份/還原參數(shù)的支持（僅拷貝備份，完成后執(zhí)行驗證備份，支持驗證和）。
• 進(jìn)行了大量的其它改進(jìn)以及錯誤修復(fù)。