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

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