选择合适的策略和工具,顺利升级到SQL Server 2012


 

???????SQL Server??????,?????SQL Server 2012???

???SQL Server 2012,??????SQL Server?????????,??????AlwaysOn???,???????????????????,????????????????????????????,???????,???????????????SQL Server 2012??

 

????????Microsoft SQL Server 2012??????????(Application Compatibility Lab),????,????????????,???????????????

????,??,?????????????????????SQL Server 2012????SQL Server 2005, 2008, 2008 R2???2012,?SQL Server 2005???SP4?,SQL Server 2008???SP2?,SQL Server 2008 R2???SP1????SQL Server 2000,????????SQL Server 2005??2008,??????SQL Server 2012?

??????,?????,?“In-place”?“Side-by-Side”,“In-place”?????????????????,???????????“Side-by-Side”???????????????????????????????,????,????????????????

  • “In-place”?????,?????????????,?????“Side-by-Side”,????????????,???????????????????
  • ??“Side-by-Side”,????????????,???????????????????,?????????,?“In-place”?????????
  • “Side-by-Side”?????????????,?????????,?????????????????,????????

????,??????????,????:

  • Microsoft SQL Server 2012 Best Practices Analyzer ???????

http://www.microsoft.com/en-us/download/details.aspx?id=29302

?????????????,??????????????????????,???????????

  • Microsoft SQL Server 2012 Upgrade Advisor ????(32??64?)

http://go.microsoft.com/fwlink/?LinkID=239679&clcid=0x409

http://go.microsoft.com/fwlink/?LinkID=239680&clcid=0x409

clip_image002

??????????:

clip_image004

?????????:

http://technet.microsoft.com/zh-cn/subscriptions/index/d85b0833-ddeb-42e3-9397-97ea60d521b7

  • Upgrade Assistant for SQL Server 2012 (UAFS) ????

clip_image006

http://www.scalabilityexperts.com/tools/downloads.html

??????????:

clip_image008

UAFS???Playback Capture Wizard(??????)?????????????,?????????????????????Transact-SQL??????????????????90%???????????????Transact-SQL???????????:

    • ??????????????
    • ????????????????
    • ??????????????
    • ??????,????????
    • ??????
Comments (1)

  1. Anonymous说道:

    数据服务是几乎所有应用都要依靠,或者对外提供的关键性服务;一些关键性应用,例如企业级应用、在线游戏、电商等,对数据服务的可用性、一致性、伸缩性等有更高的服务等级要求。 随着云计算技术的推广,越来越多的IT管理