Can multiple hostname values go to the same subscriber database?

Answered Can multiple hostname values go to the same subscriber database?

  • Freitag, 22. Februar 2013 18:11
     
     

    Our current replication uses a location column as the hostname value to differentiate where we want our partioned data to go to which server.  Now we are being asked to have multiple locations replicated to the same subscriber.  For instance:

    Location    Data

    1               Data1

    2               Data2

    Subscriber currently has subscription set to HOSTNAME = 1.  So currently it will get the first line.  Is there a way to get the second line without modifying any db schema?  I know i could add an additional column and put a rule in place that translates which locations go to which subscriber but was just curious if theres a way to specify multiple hostname values for a subscriber?

Alle Antworten