Page History
...
To copy over a list of linked servers:
- Open the Idera IDERA SQL Admin Toolset Launchpad, and then click Linked Server Copy.
- Select the source and destination SQL Server instances.
- Click Preview Missing Linked Servers.
- 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.
- 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 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
Newtabfooter |
|
...
SQL Admin Toolset delivers 24 essential administration tools. Learn more > >
...