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

  • Article

 

???????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 ???????

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

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

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

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

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

clip_image002

??????????:

clip_image004

?????????:

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

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

clip_image006

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

??????????:

clip_image008

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

    • ??????????????
    • ????????????????
    • ??????????????
    • ??????,????????
    • ??????