Post reply

How to Import Replication Monitor 'My Publishers' into SSMS across versions

  • November 8, 2017 at 6:48 am

    #409754

    I've successfully installed SQL 2017 Developer Edition and SSMS v17.3  for SQL 2017 onto my Laptop.  And I've successfully EXPORTED 120 SQL Server registrations/groups from SSMS 2016 and IMPORTED these into SSMS 2017. 

    I have 15 Publishers defined in my SQL 2016 Replication Monitor w/in 'My Publishers'.     Is there a way to EXPORT these 15 Publishers out of SQL 2016 then IMPORT them into SQL 2017 w/in Replication Monitor?

    BT

  • November 10, 2017 at 1:33 pm

    #1967596

    Express12 - Wednesday, November 8, 2017 6:48 AM

    I've successfully installed SQL 2017 Developer Edition and SSMS v17.3  for SQL 2017 onto my Laptop.  And I've successfully EXPORTED 120 SQL Server registrations/groups from SSMS 2016 and IMPORTED these into SSMS 2017. 

    I have 15 Publishers defined in my SQL 2016 Replication Monitor w/in 'My Publishers'.     Is there a way to EXPORT these 15 Publishers out of SQL 2016 then IMPORT them into SQL 2017 w/in Replication Monitor?

    I'm not aware of a way to import,export as you can with registrations.
    The publisher groups (including the My Publishers, that's the default and you can add other groups) and the publishers you added to that group are located in your profile path in the file rmsetting.xml
    I've copied the section for My Publisher and pasted it in the new rmsetting.xml file. If you try it, make sure to make a copy of the file you are modifying first.
    For 2016, the file should be located at: C:\Users\YourUserName\AppData\Roaming\Microsoft\Microsoft SQL Server\130\Tools\SQL Monitor
    For 2017, C:\Users\YourUserName\AppData\Roaming\Microsoft\Microsoft SQL Server\140\Tools\SQL Monitor
    There a My Publishers section that has the publishers you added. It would look something like:
    <Group Name="My Publishers">
      <Publisher>
       <name>Server1</name>
       <Distributor>Dist</Distributor>
       etc
      </Publisher>
      <Publisher>
       <name>Server2</name>
       <Distributor>Dist</Distributor>
       etc
      </Publisher>
     </Group>

    I've just copied that section and pasted it in the newer file for the version of SSMS.

    Sue

  • November 11, 2017 at 5:18 am

    #1967634

    thanks for your reply Sue...  Actually, I went ahead and manually added my 15+ Publishers in SQL 2017 ReplMonitor.. took me about 3 minutes..

    BT

Viewing 3 posts - 1 through 2 (of 2 total)

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