Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To copy over a list of linked servers:

  1. Open the Idera IDERA SQL Admin Toolset Launchpad, and then click Linked Server Copy.
  2. Select the source and destination SQL Server instances.
  3. Click Preview Missing Linked Servers.
  4. Either select the individual linked servers you want to copy or check the box at the top of the list to select all linked servers. All the linked servers that include a green Y in the All Passwords Moveable column are copied without any additional steps. Linked servers that include a red N require you to supply a password to copy.
  5. Click Copy Linked Servers.

...

Info

Logins that exist for the Linked Server on the source SQL Server instance are copied to the destination SQL Server instance.

Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 

...

Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse
SQL Admin Toolset delivers 24 essential administration tools. Learn more > >

 

 

...