SQL Server Performance

linked server export

Discussion in 'General Developer Questions' started by detroit, Mar 23, 2006.

  1. detroit New Member


    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
  2. satya Moderator

    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.
  3. detroit New Member

    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

Share This Page