CODEWITHSUNDEEP
sql-serversql-server-2008database-replicationmerge-replication
Thakur
Thakur

Reputation: 2020

Rename Subscription database in merge replication

I want to rename a subscription database in merge replication. All the subscriptions are synchronized properly.

IS it possible to rename one of the subscription database?

Upvotes: 0

Views: 627

Answers (1)

user1326350
user1326350

Reputation:

Yes you can

  1. Take backup of your database.
  2. Stop merge agent on the publisher.
  3. Rename the database.
  4. update db_name field in sysmergesubscriptions table bot on Subscriber as well as publisher
  5. Start the merge agent.

sample query : 

 update sysmergesubscriptions set db_name='YourDBName'
 where subscriber_server='YourSubscriber'

Upvotes: 1

Related Questions