Page History

...

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.

...

SQL Admin Toolset delivers 24 essential administration tools. Learn more > >

...