I have two SQL servers running a merge replication. The data is around 38GB in size and both sites are a high distance apart. The latency between the two sites is high. Both the publisher and subscriber are running SQL 2005. I am looking to upgrade the publisher to SQL 2012 and then a couple of months later I will upgrade the subscriber to SQL 2012. I am trying to avoid having to re-initialise the database. What is the best process for this?
I have setup a lab with two SQL 2005 servers with merge replication. I have then backed up the SQL on the publisher(ServerA) and shut the server down. I have then created a new server with the same name(ServerA) and enabled the distribution database. I then restore the publisher database with the 'With Keep_replication' flag. I can see the local publications and subscription created. But it is complaining that the publication does not exist in the distribution database. The replication will not run. Am I missing a step? Is there something else I need to restore from the SQL 2005 server.
I need to avoid having to re-initialise the merge replication.