I want to backup and restore keyspace please guide me the steps for following scenarios.
I tried few documents but not working in my case.
I have one 3 node test cluster-1 having 2 keyspace with 2 tables each. I want to backup and restore these 2 keyspace to cluster 2 which has different number of nodes i.e 2 nodes and i want to restore keyspace with different name than source node.
For eg. Cluster-1 ks names : testks_23082020 and testks_24082020
Want cluster-2 keyspace names as testks_21092020_adam and testks_23092020 but data same as that of cluster-1.
I tried using schema creation and loading sstables by stopping dse and starting post copying and sstableloader also but post restoration i am getting incompatible version for few columns .
I am using dse 6.7.4 version please guide exact steps and method. Please note node configuration is different on both cluster