How to synchronize multiple XPE SP2 Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone,

Does anyone of you have any suggestions on how to keep multiple XPE SP2
databases in sync?
The only option I have right now is SQL Server Replication which is a lot of
work for me since I am not that familiar with how it works.
Any easier way?

Thanks!
Marissa
 
Marissa said:
Hello everyone,

Does anyone of you have any suggestions on how to keep multiple XPE
SP2 databases in sync?
The only option I have right now is SQL Server Replication which is a
lot of work for me since I am not that familiar with how it works.
Any easier way?

Thanks!
Marissa
Click to expand...

Replication should work and isn't too hard to set up. However, why do you
need multiple databases? You can have a single database on a single server
while having each client connect to it remotely.
 
Hi Gordon,

We need to maintain 2 databases because of network speed issues.
Connecting clients remotely will be really slow.
One more question, with replication, will the Repositories folder be
automatically updated?
We are also maintaining 2 Repositories for the same reason as above.

Thanks!
Marissa
 
No, the repositories will be a seperate issue for you to solve. The
database has metadata about the repositories, but doesn't not "own" the
repositories. SQL Server replication wouldn't know anything about them.

Are you *sure* the network speed issues are going to be prohibitive? It
sure is an awful lot easier to use a common server. You won't want to roll
your own repository replication story if there is only one server (database
+ repositories).

--Gordon
 
The servers are separated by time zones.
Server A is in time zone A, Server B is in time zone B.
I downloaded the Repositories folder from Server A to server B and it took
me around 4-5 days. I just could not estimate how long will it take to build
using Server A.

Thanks for your help Gordon.
I'll weigh my options and choose which is the lesser evil =)

Marissa
 
Back
Top