Cov txheej txheem:

DTS pob khoom hauv SQL Server yog dab tsi?
DTS pob khoom hauv SQL Server yog dab tsi?

Video: DTS pob khoom hauv SQL Server yog dab tsi?

Video: DTS pob khoom hauv SQL Server yog dab tsi?
Video: 🕊Taennie🕊 Jennie (blackpink) & Taehyung (bts) • wedding • [fmv] 2024, Hlis ntuj nqeg
Anonim

DTS tau supersed los ntawm SQL Server Integration Services (SSIS). Hauv SQL Server , DTS ua qhov no ua haujlwm yooj yim. DTS (Data Transformation Services) yog ib txheej ntawm cov cuab yeej graphical uas tso cai rau koj hloov cov ntaub ntawv ntawm qhov chaw sib txawv rau hauv ib lossis ntau qhov chaw.

Ib yam li ib tug yuav nug, DTS pob nyob qhov twg?

Lub default folder yog tus Pob ntawv nplaub tshev, nyob hauv %Program Files%Microsoft SQL Server100 DTS . MSDB nplaub tshev teev cov Kev Pabcuam Kev Sib Koom pob khoom uas tau txais kev cawmdim rau SQL Server msdb database ntawm lub server.

Qhov thib ob, DTS pob nyob qhov twg hauv SQL Server 2008? Cov no Imported pob khoom yuav nyob ntawm qhov chaw hauv qab no hauv SQL Server tswj Studio . SQLServer > > Management > > Legacy > > Data Transformation Services. Cov DTS pob nyob rau hauv txoj kev no tsis tuaj yeem hloov kho hauv SQL Server 2005 thiab SQL Server 2008.

Tib neeg kuj nug, Kuv yuav tsim ib pob DTS li cas?

Tsim ib pob DTS

  1. Qhib pob designer.
  2. Txhais ob txoj kev sib txuas.
  3. Tsim cov ntaub ntawv twj tso kua mis.
  4. Txhais cov ntaub ntawv koj xav tsiv mus nyob thiab qhov twg koj xav muab tso rau.
  5. Txuag pob.
  6. Txoj cai nias lub npe pob thiab xaiv lub sijhawm pob.

SSIS pob hauv SQL Server yog dab tsi?

SSIS ( SQL Server Integration Services) yog ib qho kev hloov kho tshiab ntawm DTS (Cov Kev Pabcuam Hloov Cov Ntaub Ntawv), uas yog qhov tshwj xeeb ntawm cov ntawv dhau los ntawm SQL Server . SSIS pob tuaj yeem tsim hauv BIDS (Business Intelligence Development Studio). Cov no tuaj yeem siv los ua ke cov ntaub ntawv los ntawm heterogeneous cov ntaub ntawv mus rau hauv SQL Server.

Pom zoo: