Hi, I have a distribution name I want to change (there are client-generated columns, so I want to prefix all my columns with underscore). I tried sp_rename (when there was only 1 table, 1 federation), but it only seems to rename the column and when
I split it just replicated the data across the 2 new federations.
So is there a command that changes distribution name? Thanks.
Seems you tired to rename distribution name, basically this isn't a supported way to do this.
Since the replication is picking the data up from the tables in the distribution and publisher databases. If you change the replication metadata, then everything will reflect the new name. But, modifying the replication metadata is NOT supported.
If you want to change the name, I am afraid you need to rebuild the replication and configure the distribution as well.