Merge replication using files.

Is it possible to use merge replication without direct connection from suscriber/publisher? I'm trying to find a solution to use files for send/receive merge-replication info from/to server.

^_^,

Thank You.

There is currently no support for Merge replication with files.

Are you concerned about the snapshot fules or you want all of the syncs to be using files? If the former, you should look at alt_snapshot_folder. If the latter, there is no support as of now.

|||

I needed for all syncs :(.

Do you feel there's a way to bypass merge-web-synchronization and use files to do sync.?

I don't know the communication process, but simplifying, maybe we can merge request/s in an ouput file, and response/s in an input file ...

Than you.

|||

Hi,

Thanks for your suggestion. This is not a new idea and has been floating in our minds for some time. We may probably take another look at it for the next release but it may not make it.

Merge replication question

Hi,
we have a merge replication SQL Server 200 solution that worked fine so far;
2 days ago we put a new table in replication and something new, that we
didn't see before happened: for some reason not all the records where bcp in
the new table for one of the subscriptions and there is a sp_upd ...
(strange name after upd) that runs every 1 minute and 4 seconds.
Any ideas?
Thank you so much!
use the conflict viewer to determine if there were any conflicts which might
account for the missing rows. Also the sp_upd statement means that there
are changes on the publisher which are being performed on the subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sorin" <Sorin@.discussions.microsoft.com> wrote in message
news:5674968D-EE90-4348-8705-83BA8659ED75@.microsoft.com...
> Hi,
> we have a merge replication SQL Server 200 solution that worked fine so
far;
> 2 days ago we put a new table in replication and something new, that we
> didn't see before happened: for some reason not all the records where bcp
in
> the new table for one of the subscriptions and there is a sp_upd ...
> (strange name after upd) that runs every 1 minute and 4 seconds.
> Any ideas?
> Thank you so much!

Merge Replication and SQL 2005, help!

I'm working on developing a software solution using Mobile Client Software Factory. Let me start off by saying that this package is such a dream come true, and I can't thank the guys who put this together enough. The problem is, we're having some trouble getting the components setup for the Framework to work, in particular with SQL Server 2005.

We have SQL Server 2005 running on a machine, and we have our entire database setup what I believe to be correctly. Last night, we tried for hours to get the PPC Emulator running our version of the Framework to connect to the SQL Server (On another machine on the same LAN) to no avail.

We published just one table to test with, we have the snapshot created, the web service is running, and yet it won't let us connect. The most common error we're getting from the webservice log is: Hr=80004005 ERR:OpenDB failed getting pub version 28627.

I was just wondering if someone out there had a guide for correctly setting up SQL Server 2005 for merge replication so that remote clients can access the server through the webservice over the internet. If there is anything specifically special that needs to be done to work with the Mobile Client Software Factory, that would be great to know too.

I'd really appreciate some help, and thanks in advance to anyone who can lend some advice.

Cheers!

Andrew

I don't know what Mobile Client Software Factory is, but if you have merge subscriptions on a disconnected network, but has access to the internet, you can use merge web synchronization, which is synchronizing over the internet. There's more information in books online, search for replication web synchronization.