SQL Server Performance Forum – Threads Archive

linked server export

Does anyone know the easiest way to transfer linked servers from one server to another without having to manually set them up? I can’t seem to script them, I looked into the sysservers table, I don’t want to insert into a system table until I have to? There has to be a better way, has anyone run across this? Thanks

I don’t think there are any, the best way is run PROFILER while you’re setting up linked servers with required servers. Then use the script generated by PROFILER on other boxes. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks Satya, I did find this as well. If you are familiar with C# and SQL DMO it isn’t so bad. I think I had to log in to get the source. It’s basically a C# app that reads the attributes and generates the TSQL scripts needed to recreate the linked servers. http://www.codeproject.com/cs/database/ScriptLinkedServers.asp Thanks

]]>