Post reply

Linked servers migration

  • September 7, 2016 at 1:20 am

    #313115

    Is it possible to script all 40+ linked servers together and migrate it to new MSSQL 2012 instance without opting to script one linked server at a time ?

  • September 7, 2016 at 1:50 am

    #1899513

    Yes. Click on Linked Servers in Object Explorer, then go to the Object Explorer Details window. Select all the linked servers, right-click and choose Script Linked Server as.

    John

  • September 7, 2016 at 1:58 am

    #1899515

    it doesn't help to script all linked servers together ..it will just do one by one

  • September 7, 2016 at 2:04 am

    #1899516

    It does for me. Generates a huge long script with lots of sp_addlinkedserver statements (and others). Are you sure you're in Object Explorer Details, not Object Explorer?

    John

  • September 7, 2016 at 5:01 am

    #1899529

    Super !!!!!!! I am able to find it ...

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply