Need references for .Net app replicating SQL2005 database to the laptops

[Earl]

Can anyone point me to some good references for coding a Winforms app to
trigger replication (merge preferably) on SQL2005? I'm setting up a scenario
where I want my app to allow multiple laptops to synchronize to the
distribution SQL2005 database and I'd like to do it either automatically or
by having them click on a menu/button. From working with merge in the
CompactFramework, I know the general approach but I do not know the
equivalent namespaces or techniques in the "big framework".

 

[Mr. Arnold]

Can anyone point me to some good references for coding a Winforms app to
trigger replication (merge preferably) on SQL2005? I'm setting up a
scenario where I want my app to allow multiple laptops to synchronize to
the distribution SQL2005 database and I'd like to do it either
automatically or by having them click on a menu/button. From working with
merge in the CompactFramework, I know the general approach but I do not
know the equivalent namespaces or techniques in the "big framework".

Maybe, this link will get you started, with the second article in the link
about RMO.

http://www.yukonxml.com/

 

[Earl]

Thanks for the link (good stuff on that site!) but I saw no link article on
"RMO."

 

[Mr. Arnold]

Thanks for the link (good stuff on that site!) but I saw no link article
on "RMO."

 

[Mr. Arnold]

Thanks for the link (good stuff on that site!) but I saw no link article
on "RMO."

Maybe, this will do it for you.

I am really not having too hard of a time finding this stuff with Google.
Google is your friend.

http://msdn2.microsoft.com/en-us/li...tion.replicationserver.replicationserver.aspx
http://wardyit.com/blog/blog/archive/2006/03/14/94.aspx

 

[Earl]

Yeah, I'm not having trouble finding "stuff" on replication with Google
either. Tons of SQL Server based information on replication out there (I
even have Hilary Cotter's book for that matter). But finding information on
app development with 2005 replication is another story -- not that many
people doing it apparently. Microsoft has one example for the Adventureworks
database on the Technet website, but I've found very little on Google for
new app development involving replication (I've built a lot of SQLCE stuff
with replication, but nothing since 2003 and nothing for Winforms). Might be
time to add to my tech book collection.

Thanks for the link.

 

[Guest]

You might want to check out the merge replication sample we added with SQL
Server 2005. It does what you are suggesting:

http://msdn2.microsoft.com/en-us/library/ms160955(SQL.90).aspx

 

[Earl]

Thanks Glenn. That looks on point.

You might want to check out the merge replication sample we added with SQL
Server 2005. It does what you are suggesting:

http://msdn2.microsoft.com/en-us/library/ms160955(SQL.90).aspx

--
Glenn Gailey
SQL Server User Education

This posting is provided "AS IS" with no warranties, and confers no
rights.