推薦：怎樣通過SQLyog分析MySQL數(shù)據(jù)庫
SOLyog的下載、安裝以及使用很簡單。我去了相關(guān)網(wǎng)站下載，它只有384K字節(jié)大

在許多情況下，當遷移至SQL Server 2008之前必須了解那些反對和放棄功能的具體情況。

下文是幾個主要功能在兼容性上的問題列表：

1.SQL Server Analysis Services Backward Compatibility

[放棄] - Discontinued Analysis Services Functionality in SQL Server 2008

[反對] - Deprecated Analysis Services Functionality in SQL Server 2008

[行為變化] - Behavior Changes to Analysis Services Features in SQL Server 2008

[破壞變化] - Breaking Changes to Analysis Services Features in SQL Server 2008

2.SQL Server Database Engine Backward Compatibility

[反對] - Deprecated Database Engine Features in SQL Server 2008

[放棄] - Discontinued Database Engine Functionality in SQL Server 2008

[破壞變化] - Breaking Changes to Database Engine Features in SQL Server 2008

[行為變化] - Behavior Changes to Database Engine Features in SQL Server 2008

3.Integration Services Backward Compatibility

[反對] - Deprecated Integration Services Features in SQL Server 2008

[放棄] - Discontinued Integration Services Functionality in SQL Server 2008

[破壞變化] - Breaking Changes to Integration Services Features in SQL Server 2008

[行為] - Behavior Changes to Integration Services Features in SQL Server 2008

[支持數(shù)據(jù)轉(zhuǎn)換服務(wù)] - Support for Data Transformation Services (DTS) in SQL Server 2008

4.Reporting Services Backward Compatibility

[反對] - Deprecated Features in SQL Server Reporting Services

[放棄] - Discontinued Functionality in SQL Server Reporting Services

[破壞變化] - Breaking Changes in SQL Server Reporting Services

[行為變化] - Behavior Changes in SQL Server Reporting Services

5.Full-Text Search Backward Compatibility

[反對] - Deprecated Full-Text Search Features in SQL Server 2008

[放棄] - Discontinued Full-Text Search Features in SQL Server 2008

[破壞變化] - Breaking Changes to Full-Text Search in SQL Server 2008

[行為變化] - Behavior Changes to Full-Text Search in SQL Server 2008

6.Replication Backward Compatibility

[反對] - Deprecated Features in SQL Server Replication

[放棄] - Discontinued Functionality in SQL Server Replication

[行為變化] - Behavior Changes in SQL Server Replication

[破壞變化] - Breaking Changes in SQL Server Replication

[支持Replication數(shù)據(jù)到不同版本的SQL Server數(shù)據(jù)庫] - Using Multiple Versions of SQL Server in a Replication Topology

升級前使用Upgrade Advisor to Prepare工具可以分析當前SQL Server的安裝情況，可以生成一個提示升級前后需要修補的問題的報表。

分享：怎樣處理SQL Server日志文件總結(jié)及日志滿的問題
事務(wù)日志(Transaction logs)是數(shù)據(jù)庫結(jié)構(gòu)中非常重要但又經(jīng)常被忽略的部分。由于它并不像數(shù)據(jù)庫中的schema那樣活躍，因此很少有人關(guān)注事務(wù)日志。 事務(wù)日志是針對數(shù)據(jù)庫改變所做的記錄，它可以記錄針對數(shù)據(jù)庫的任何操作，并將記錄結(jié)果保存在獨立的文件中。對于