Cov txheej txheem:

Kuv yuav teeb tsa tus neeg rau zaub mov txuas hauv SQL Server 2014 li cas?
Kuv yuav teeb tsa tus neeg rau zaub mov txuas hauv SQL Server 2014 li cas?

Video: Kuv yuav teeb tsa tus neeg rau zaub mov txuas hauv SQL Server 2014 li cas?

Video: Kuv yuav teeb tsa tus neeg rau zaub mov txuas hauv SQL Server 2014 li cas?
Video: Data Science with Python! Analyzing File Types from Avro to Stata 2024, Lub peb hlis ntuj
Anonim

Txhawm rau ntxiv cov neeg siv txuas txuas siv SSMS (SQL Server Management Studio), qhib lub server koj xav tsim qhov txuas los ntawm cov khoom tshawb nrhiav

  1. Hauv SSMS, nthuav tawm Server Cov khoom -> Txuas Servers -> (Right click on the Txuas Server Folder thiab xaiv "Tshiab Txuas Server ”)
  2. Qhov “New Txuas Server ” Dialog tshwm.

Ntxiv mus, kuv yuav ua li cas los tsim ib lub server txuas hauv SQL 2014?

Txhawm rau tsim ib lub server txuas:

  1. Hauv Object Explorer, qhib Server Objects thiab mus rau Linked Servers.
  2. Txoj nyem rau ntawm Linked Servers thiab xaiv New Linked Server:
  3. Ua kom tiav cov ntsiab lus rau lub server txuas.
  4. Nyob rau hauv kev xaiv kev ruaj ntseg, koj muaj peev xwm los qhia cov neeg siv hauv zos rau tus neeg siv ntawm lub tshuab tej thaj chaw deb.

Ib sab saum toj no, kuv yuav nrhiav tau cov servers txuas hauv SQL li cas? Txhawm rau pom txhua tus tsim txuas servers hauv SSMS, nyob rau hauv Object Explorer, xaiv Server Objects nplaub tshev thiab nthuav cov Linked Servers folder:

  1. Txhawm rau tsim ib tus neeg rau zaub mov txuas hauv SSMS, txoj nyem rau ntawm Linked Servers nplaub tshev thiab los ntawm cov ntawv qhia zaub mov xaiv qhov kev xaiv Tshiab Linked Server:
  2. Lub New Linked Server dialog tshwm:

Tom qab ntawd, kuv yuav teeb tsa SQL txuas server li cas?

Siv SQL Server Management Studio

  1. Nyob rau hauv SQL Server Management Studio, qhib Object Explorer, nthuav Server Objects, right-click Linked Servers, thiab tom qab ntawd nyem New Linked Server.
  2. Ntawm nplooj ntawv dav dav, hauv lub thawv Linked server, ntaus lub npe ntawm qhov piv txwv ntawm SQL Server uas koj cheeb tsam txuas rau.

Kuv yuav txuas mus rau SQL Server li cas los ntawm ib lub server mus rau lwm tus?

Ua raws li cov kauj ruam no los tsim Linked Server:

  1. Server Objects -> Linked Servers -> New Linked Server.
  2. Muab lub npe neeg rau zaub mov chaw taws teeb.
  3. Xaiv Hom Chaw Taws Teeb (SQL Server lossis Lwm Yam).
  4. Xaiv Kev Ruaj Ntseg -> Ua kom siv cov ntsiab lus kev nyab xeeb no thiab muab tus ID nkag mus thiab lo lus zais ntawm cov chaw taws teeb server.
  5. Nyem OK thiab koj ua tiav !!

Pom zoo: