当前位置: 首页 > 图文教程 > 数据库 > MSSQL > SQL Server 2008主要功能在兼容性上的问题

MSSQL
SQL数据操作基础(初级)3
SQL数据操作基础(初级)4
SQL数据操作基础(初级)5
SQL数据操作基础(中级)6
SQL数据操作基础(中级)7
SQL数据操作基础(中级)8
SQL数据操作基础(中级)9
SQL数据操作基础(中级)10
如何找出消耗cup的进程信息和执行的语句
改善SQL Server内存管理
减少SQL日志的三种方法
SQL脚本生成的一些BUG(1)
SQL脚本生成的一些BUG(2)
sqlserver日志文件总结及充满处理
启动SQL SERVER时自动执行存储过程
SQL Server 连接基础知识
修改用户定义的数据类型
利用MSSQL sp自制未公开的加密函数
让你的SQL运行速度明显提高
十大绝招保护SQL Server数据库安全

MSSQL 中的 SQL Server 2008主要功能在兼容性上的问题


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-10-17   浏览: 113 ::
收藏到网摘: n/a

在许多情况下,当迁移至SQL Server 2008之前必须了解那些反对和放弃功能的具体情况。

下文是几个主要功能在兼容性上的问题列表:

1.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

2.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

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

[支持数据转换服务] - 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.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数据到不同版本的SQL Server数据库] - Using Multiple Versions of SQL Server in a Replication Topology

6.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

升级前使用Upgrade Advisor to Prepare工具可以分析当前SQL Server的安装情况,可以生成一个提示升级前后需要修补的问题的报表。