We have merge replication setup with a publisher, a distributor and 28 subscribers. Now we need to migrate the publisher and distributor servers to another server running on VMWare environment over the private Cloud.
There are a few challenges for us for this migration exercise -
1) Our current data center has very limited access to the cloud environment which only allows us to do remote desktop or web portal.
2) Limited bandwidth between our Data Center and Cloud which is only 40 MB.
3) After restore the publisher and distributor, we couldn't afford to reinitialized all the 28 subscribers due to limited bandwidth of our subscriber connection which is only 2 MB.
4) Our down time is only 8 hours and we have to complete everything within this window.
I have experience in migrating other database servers to the cloud but those database servers did not have any replications. This is my first time to migrate the database servers with merge replication to another server.
Kindly advise me what should be the steps to restore the publisher and distributor without the need of reinitializing the replications.
I have both push and pull merge replications and subscribers are using the Microsoft Synchronization Manager to sync the pull replication.
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
How to fix incompatible JVM issue while installing Eclipse
While installing Eclipse in windows, got one error like above and unable to proceed with the installation.
This video describes how to successfully install Eclipse.
How to solve incompa…