we are migrating the data from one couchbase cluster to another couchbase cluster using XDCR. We can check in the admin console about the XDCR progress. I want to do bucket level data verification among two data base cluster I think there is no straight forward method to do data verification , is there any other workaround to achieve this ???
@Selvam_Veerappan You can do this in multiple ways once the replication has caught up:
- You can use https://docs.couchbase.com/server/current/tools/cbexport.html to export data from both the clusters in a desired format and do some scripting to diff them out
- You can use any of our SDK clients to read and compare data in both the clusters
- You can write a script using our N1QL queries to cross check the data between the clusters