The Linked Server Copy tool allows you to copy your linked servers from one SQL Server instance to another along with the associated settings and permissions, saving you the time it would take to move linked servers manually. With this tool you can:
You can copy all linked SQL Server instances. If the remote authentication on a SQL Server instance is SQL Server authentication, must provide the password. You can copy all other linked servers without any additional steps.
If the type of provider is not compatible with the host, the copied linked server does not work correctly. For example, a jet provider (32-bit only) copied to a 64-bit system does not work. |
Logins that exist for the Linked Server on the source SQL Server instance are copied to the destination SQL Server instance. |