Cov txheej txheem:

Kuv yuav ua li cas thiaj tsim tau ib daim ntawv teev kev pabcuam kev koom ua ke?
Kuv yuav ua li cas thiaj tsim tau ib daim ntawv teev kev pabcuam kev koom ua ke?

Video: Kuv yuav ua li cas thiaj tsim tau ib daim ntawv teev kev pabcuam kev koom ua ke?

Video: Kuv yuav ua li cas thiaj tsim tau ib daim ntawv teev kev pabcuam kev koom ua ke?
Video: Rov Ntsib Koj Zaum Ob BY Nuj Xeem nkauj Tshiab -13/02/2021 2024, Hlis ntuj nqeg
Anonim

Txhawm rau tsim SSISDB catalog hauv SQL Server Management Studio

  1. Qhib SQL Server Management Studio.
  2. Txuas mus rau SQL Server Database Engine.
  3. Hauv Object Explorer, nthuav cov server node, right-click lub Integration Services Catalogs node, thiab ces nias Tsim Catalog .
  4. Nyem Enable CLR Kev koom ua ke .

Kuj kom paub yog, Dab tsi yog Kev Pabcuam Kev Sib Koom Tes Catalog?

The SSISDB catalog yog lub hauv paus ntsiab lus rau kev ua haujlwm nrog Kev pabcuam kev koom ua ke (SSIS) tej yaam num uas koj tau xa mus rau Kev pabcuam kev koom ua ke server. Cov khoom uas khaws cia hauv SSISDB catalog suav nrog tej yaam num, tej pob khoom, tsis, ib puag ncig, thiab ua hauj lwm keeb kwm.

Kuv yuav pab tau SQL Server Integration Services li cas? Txuas mus rau Kev Pabcuam Kev Sib Txuas

  1. Nyem Pib, taw tes rau Txhua Qhov Kev Pabcuam, taw rau Microsoft SQL Server, thiab tom qab ntawd nyem SQL Server Management Studio.
  2. Nyob rau hauv Connect to Server dialog box, xaiv Integration Services nyob rau hauv cov npe neeg rau zaub mov, muab ib tug neeg rau zaub mov lub npe nyob rau hauv lub Server lub npe lub thawv, thiab ces nias Txuas. Tseem ceeb.

Tsis tas li, kuv tuaj yeem tau txais pob SSIS los ntawm Kev Pabcuam Kev Sib Koom Tes Li Cas?

Option 2: Exporting los ntawm Integration Services Catalog i.e. SSISDB

  1. Nrhiav qhov project deployed yog koj SSIS Catalog.
  2. Txoj nyem rau ntawm qhov project thiab ces ntaus Export thiab txuag cov ntaub ntawv li ispac.
  3. Tom qab ntawd rename lub. ispac rau. zip.
  4. Tsim ib txoj haujlwm SSIS thiab ntxiv cov pob khoom uas twb muaj lawm / pob ntawv koj xav tau los ntawm zip file extract.

Kuv yuav ntxiv Ssisdb li cas?

Kauj ruam yog kauj ruam qhia ntxiv SSISDB rau SQL neeg rau zaub mov 2016 Ib txwm On Availability Group (AG)

  1. Kauj ruam 1: Tsim SSIDB ntawm thawj replica:
  2. Kauj ruam 2: Configure Integration Service Catalog:
  3. Kauj Ruam 3: Ntxiv SSISDB rau Pab Pawg Muaj:
  4. Kauj ruam 4: Xaiv database thiab decryption password:
  5. Kauj ruam 5: Xaiv Secondary Replicas:

Pom zoo: