I have a situation in which I have 3 office locations
which do not share a common domain and are connected to
each other via TCP/IP through a DSL connection(no t-1 or t-
3). The requirement is that they all in be sync and that
laptops for mobile users be able to be synced as well on
connection.
Using the client network utility, we set up an alias for
each office so we could connect successfully. I was able
to get merge replication set up, or so it seemed, and
attempted a sync knowing ahead of time that there were
many differences in the database between each office. The
sync came up dry with no data being merged and no errors
being reported. I took the following steps:
1) Forced a validation with checksum and record count
2) Forced a new snapshot
3) Forced a new resync among the locations
This brought no results of data transfer among the
participating offices. I have removed replication from
the boxes three times trying to get a different result
but to no avail reach the same result. I need help and I
need it fast!!!!
Please e-mail me with questions or suggestions at
Regards,
Craig Johnson
Durham, NC