Kuv yuav hloov cov qib compatibility ntawm ib database li cas?
Kuv yuav hloov cov qib compatibility ntawm ib database li cas?

Video: Kuv yuav hloov cov qib compatibility ntawm ib database li cas?

Video: Kuv yuav hloov cov qib compatibility ntawm ib database li cas?
Video: YWJ KOJ SIAB Official music video by: Dang Thao 2024, Tej zaum
Anonim

Hloov rau qhov sib txawv qib compatibility , siv cov ALTER DATABASE hais kom ua raws li qhia hauv qhov piv txwv hauv qab no: Siv Master Go ALTER DATABASE < database npe>SET COMPATIBILITY_LEVEL = < kev sib haum xeeb - qib >; Yog tias koj xav tau, koj tuaj yeem siv tus wizard hloov cov qib compatibility.

Ib yam li ntawd, kuv yuav hloov cov qib compatibility hauv SQL li cas?

Nws yog ib qho yooj yim heev rau hloov tus database compatibility qib . Hauv SQL ntawv Server Management Studio (SSMS), right-click on the database npe, xaiv Properties, xaiv qhov Options node, nyem rau ntawm lub nco-down ib sab ntawm Qib Compatibility thiab xaiv cov qib uas phim koj SQL ntawv Server.

Ib sab saum toj no, database compatibility qib hauv SQL Server yog dab tsi? Nrog SQL Server 2012 thiab laus dua, the database compatibility qib feem ntau yog siv los tswj seb cov yam ntxwv tshiab qhia nrog ib qho version ntawm SQL Server tau qhib los yog tsis tau thiab seb cov yam ntxwv qub uas tsis muaj kev txhawb nqa tau raug xiam lossis tsis tau.

Ua raws li qhov no hauv kev txiav txim siab, kuv yuav ua li cas thiaj nrhiav tau qib sib xws ntawm cov ntaub ntawv?

Rau saib tus qib compatibility ntawm txhua tus database , right click lub database hauv SQL Server Management Studio thiab xaiv Properties, ces nyem qhov Options tab.

Puas yog SQL Server rov qab tau tshaj?

SQL Server 2016 yog rov qab sib xws rau hauv qab no SQL Server versions: SQL Server 2016 (130) SQL Server 2014 (120) SQL Server 2012 (110)

Pom zoo: