So if I have a remote location running Express that needs to publish data to
a central server, Enterprise edition, can I do that or is it not possible
due to Express being a Subscriber only for Merge and Transactional
Replication?
If this is not possible, what would be the best way to handle the publishing
of data from the remote to the central location taken into account the fact
that the remote is on a dial-up internet connection only available during
off-hours?
TIA
Michael MacGregor
Database Architect
I'd set it up as a merge subscriber - this allows for offline access and
will send data back to the publisher.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment