ProHoster > Π‘Π»ΠΎΠ³ > Kev tswj hwm > Hloov cov ntaub ntawv thaub qab los ntawm tus tshiab version ntawm MS SQL Server mus rau ib qho qub version

Hloov cov ntaub ntawv thaub qab los ntawm tus tshiab version ntawm MS SQL Server mus rau ib qho qub version

prehistory

Ib zaug, txhawm rau tsim cov kab laum, kuv xav tau ib qho thaub qab ntawm cov ntaub ntawv tsim khoom.

Ua rau kuv xav tsis thoob, kuv tau khiav mus rau cov kev txwv hauv qab no:

  1. Lub database backup tau ua nyob rau hauv lub version SQL neeg rau zaub mov 2016 thiab tsis sib haum nrog kuv SQL neeg rau zaub mov 2014.
  2. Hauv kuv lub computer ua haujlwm, OS siv tau lub qhov rais 7yog li kuv kho tsis tau SQL neeg rau zaub mov mus txog version 2016
  3. Cov khoom txhawb nqa yog ib feem ntawm cov txheej txheem loj dua nrog kev sib txuas ua ke ntawm cov cuab yeej cuab tam thiab tseem hais lus rau lwm cov khoom thiab cov hauv paus, yog li nws yuav siv sij hawm ntev heev los xa mus rau lwm qhov chaw nres tsheb.

Muab cov lus saum toj no, kuv tuaj txog qhov xaus tias lub sijhawm tau los rau cov ntoo khaub lig ntawm cov kev daws teeb meem tsis zoo.

Restoring cov ntaub ntawv los ntawm ib tug thaub qab

Kuv xaiv siv lub tshuab virtual Oracle VM VirtualBox nrog Windows 10 (koj tuaj yeem nqa cov duab sim rau Edge browser ntawm no). SQL Server 2016 tau nruab rau ntawm lub tshuab virtual thiab daim ntawv thov database tau rov qab los ntawm kev thaub qab (phau ntawv).

Configuring nkag mus rau SQL Server ntawm lub tshuab virtual

Tom ntej no, nws yuav tsum tau ua qee cov kauj ruam kom nkag mus rau SQL Server los ntawm sab nraud:

  1. Rau lub firewall, ntxiv ib txoj cai hla kev thov chaw nres nkoj 1433.
  2. Nws yog qhov tsim nyog tias kev nkag mus rau lub server tsis mus dhau ntawm windows authentication, tab sis los ntawm SQL siv tus ID nkag mus thiab lo lus zais (nws yooj yim dua rau kev nkag mus). Txawm li cas los xij, nyob rau hauv rooj plaub no, koj yuav tsum nco ntsoov ua kom SQL Authentication hauv SQL Server cov khoom.
  3. Hauv cov neeg siv kev teeb tsa ntawm SQL Server ntawm lub tab Tus neeg siv daim ntawv qhia qhia tus neeg siv lub luag haujlwm rau cov ntaub ntawv rov qab db_securityadmin.

Kev hloov ntaub ntawv

Qhov tseeb, cov ntaub ntawv hloov nws tus kheej muaj ob theem:

  1. Kev hloov cov ntaub ntawv schema (cov ntxhuav, kev pom, cov txheej txheem khaws cia, thiab lwm yam)
  2. Hloov cov ntaub ntawv nws tus kheej

Hloov cov ntaub ntawv schema

Peb ua cov haujlwm hauv qab no:

  1. Xaiv Tasks -> Tsim Scripts rau lub hauv paus portable.
  2. Xaiv cov khoom koj xav tau hloov lossis tawm ntawm tus nqi qub (hauv qhov no, cov ntawv sau yuav raug tsim rau txhua yam khoom siv database).
  3. Qhia qhov chaw rau txuag cov ntawv. Nws yog qhov yooj yim tshaj plaws los khaws cov ntawv hauv ib daim ntawv Unicode. Tom qab ntawd, yog tias tsis ua haujlwm, koj tsis tas yuav rov ua txhua kauj ruam dua.

Thaum tsab ntawv tau txais kev cawmdim, nws tuaj yeem khiav ntawm tus thawj SQL Server (qub version) los tsim lub hauv paus xav tau.

Ceeb toom: Tom qab ua tiav tsab ntawv, koj yuav tsum tau tshawb xyuas cov ntawv xov xwm ntawm qhov chaw ntawm cov ntaub ntawv los ntawm kev thaub qab thiab cov ntaub ntawv tsim los ntawm tsab ntawv. Hauv kuv rooj plaub, tsis muaj qhov teeb tsa rau COLLATE hauv tsab ntawv, uas ua rau tsis ua haujlwm thaum hloov cov ntaub ntawv thiab seev cev nrog tambourine los tsim cov ntaub ntawv siv cov ntawv ntxiv.

Kev hloov ntaub ntawv

Ua ntej hloov cov ntaub ntawv, koj yuav tsum lov tes taw kev kuaj xyuas ntawm txhua qhov kev txwv ntawm cov ntaub ntawv:

EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all'

Hloov cov ntaub ntawv yog nqa tawm siv cov ntaub ntawv import wizard Tasks -> Ntshuam cov ntaub ntawv ntawm SQL Server, qhov chaw database tsim los ntawm tsab ntawv nyob:

  1. Qhia meej qhov chaw sib txuas rau qhov chaw (SQL Server 2016 ntawm lub tshuab virtual). Kuv siv cov ntaub ntawv SQL Server Native Client thiab SQL authentication tau hais los saum no.
  2. Qhia meej qhov chaw sib txuas rau lub hom phiaj (SQL Server 2014 ntawm lub tshuab host).
  3. Tom ntej no, teeb tsa daim ntawv qhia. Txhua yam yuav tsum raug xaiv tsis nyeem nkaus xwb khoom (piv txwv li, views tsis tas yuav tsum tau xaiv). Raws li kev xaiv ntxiv, xaiv "Cia kev nkag mus rau hauv kab ntawv tus kheej"yog tias siv li ntawd.
    Ceeb toom: yog tias, thaum sim xaiv ob peb lub rooj thiab teeb tsa lawv cov cuab yeej "Cia kev nkag mus rau hauv kab ntawv tus kheej" cov cuab yeej twb tau teem rau tsawg kawg yog ib lub rooj xaiv, lub dialog yuav qhia tias cov cuab yeej twb tau teem rau tag nrho cov xaiv rooj. Qhov tseeb no tuaj yeem ua rau tsis meej pem thiab ua rau muaj kev tsiv teb tsaws chaw.
  4. Peb pib qhov kev hloov.
  5. Restoring constraint checking: 
    EXEC sp_msforeachtable 'ALTER TABLE ? CHECK CONSTRAINT all'

Yog tias muaj teeb meem tshwm sim, peb tshawb xyuas cov chaw, tshem tawm cov ntaub ntawv tsim nrog qhov yuam kev, rov tsim nws los ntawm tsab ntawv, kho thiab rov ua cov ntaub ntawv hloov pauv.

xaus

Txoj haujlwm no tsis tshua muaj thiab tshwm sim tsuas yog vim cov kev txwv saum toj no. Qhov kev daws teeb meem tshaj plaws yog txhawm rau txhim kho SQL Server lossis txuas mus rau cov chaw taws teeb chaw taws teeb yog tias daim ntawv thov architecture tso cai rau nws. Txawm li cas los xij, tsis muaj leej twg tiv thaiv los ntawm txoj cai qub txeeg qub teg thiab txhais tes ntawm kev txhim kho tsis zoo. Kuv vam tias koj yuav tsis xav tau cov lus qhia no, tab sis yog tias koj tseem xav tau nws, nws yuav pab txuag tau ntau lub sijhawm thiab paj hlwb. Ua tsaug rau koj mloog!

Daim ntawv teev cov peev txheej siv

Tau qhov twg los: www.hab.com