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?