Cov txheej txheem:

Dab tsi yog database script?
Dab tsi yog database script?

Video: Dab tsi yog database script?

Video: Dab tsi yog database script?
Video: Yog hmoov dab tsi By karaoke #nimyaivnimyai #karaokehmoob 2024, Hlis ntuj nqeg
Anonim

Cov Database Scripts qhov project yog ib kab lus txib ntawv uas yuav dump, lwv, restore thiab merge databases . Lawv tau tsim tshwj xeeb los ua haujlwm zoo tshaj plaws thaum tsim nyob rau hauv ib puag ncig tswj hwm. Lub hom phiaj tseem ceeb yog: khaws cia database nyob rau hauv sync nrog code. khaws cia muaj peev xwm siv lub vev xaib GUI.

Tsis tas li ntawd, tsab ntawv hauv SQL yog dab tsi?

A SQL ntawv yog ib txheej ntawm SQL ntawv cov lus txib tau khaws cia ua cov ntaub ntawv hauv SQL Scripts . A SQL ntawv tuaj yeem muaj ib lossis ntau dua SQL ntawv nqe lus los yog PL/ SQL ntawv thaiv. Koj siv tau SQL Scripts tsim, kho, saib, khiav, thiab rho tawm tsab ntawv cov ntaub ntawv. SQL Scripts tsis txhawb bind variables.

Ib yam li ntawd, koj txhais li cas los ntawm tsab ntawv? Tsab ntawv . Ib lub computer tsab ntawv yog ib daim ntawv teev cov lus txib uas raug tua los ntawm ib qho kev pab cuam lossis sau ntawv cav. Cov ntawv tej zaum yuav raug siv los ua cov txheej txheem ntawm lub computer hauv zos lossis tsim cov nplooj ntawv hauv Web. Tsab ntawv cov ntaub ntawv feem ntau tsuas yog cov ntawv nyeem uas muaj cov lus qhia sau rau hauv ib qho sau ntawv lus.

Hauv qhov no, kuv yuav ua li cas thiaj li tau txais SQL Server database tsab ntawv?

Tsim Database Script hauv SQL Server

  1. Qhib SQL Server 2008 thiab xaiv cov ntaub ntawv uas koj xav tsim cov ntawv rau.
  2. Tam sim no right-click lub database ces Tasks-> Tsim cov ntawv.
  3. Tom qab ntawd lub qhov rais yuav qhib.
  4. Tom qab ntawd, hauv "Table View Options" ua qhov tseeb "Script data".
  5. Nyem qhov khawm tiav.

Kuv tuaj yeem tsim cov ntaub ntawv li cas?

Tsim ib tug dawb paug database

  1. Ntawm Cov Ntaub Ntawv tab, nyem Tshiab, thiab tom qab ntawd nyem Blank Database.
  2. Ntaus ib lub npe cov ntaub ntawv nyob rau hauv cov ntaub ntawv npe lub thawv.
  3. Nyem Tsim.
  4. Pib ntaus ntawv ntxiv cov ntaub ntawv, lossis koj tuaj yeem muab cov ntaub ntawv los ntawm lwm qhov chaw, raws li tau piav qhia hauv ntu Luam cov ntaub ntawv los ntawm lwm qhov chaw rau hauv lub rooj nkag.

Pom zoo: