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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Earl - 06 Jun 2007 07:35 GMT

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".

Reply to this Message

Mr. Arnold - 06 Jun 2007 11:59 GMT

> 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
[quoted text clipped - 3 lines]
> 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/

Reply to this Message

Earl - 06 Jun 2007 16:39 GMT

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

>> 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
[quoted text clipped - 8 lines]
>
> http://www.yukonxml.com/

Reply to this Message

Mr. Arnold - 06 Jun 2007 20:07 GMT

> Thanks for the link (good stuff on that site!) but I saw no link article
> on "RMO."
[quoted text clipped - 11 lines]
>>
>> http://www.yukonxml.com/

Reply to this Message

Mr. Arnold - 06 Jun 2007 20:13 GMT

> 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/library/microsoft.sqlserver.replication.replica
tionserver.replicationserver.aspx
http://wardyit.com/blog/blog/archive/2006/03/14/94.aspx

Reply to this Message

Earl - 06 Jun 2007 23:34 GMT

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.

>> Thanks for the link (good stuff on that site!) but I saw no link article
>> on "RMO."
[quoted text clipped - 6 lines]
> http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.replication.replica
tionserver.replicationserver.aspx
> http://wardyit.com/blog/blog/archive/2006/03/14/94.aspx

Reply to this Message

Glenn Gailey [MS] - 11 Jun 2007 16:10 GMT

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

Signature

Glenn Gailey
SQL Server User Education

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

> 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
[quoted text clipped - 3 lines]
> CompactFramework, I know the general approach but I do not know the
> equivalent namespaces or techniques in the "big framework".

Reply to this Message

Earl - 12 Jun 2007 01:12 GMT

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:
[quoted text clipped - 10 lines]
>> CompactFramework, I know the general approach but I do not know the
>> equivalent namespaces or techniques in the "big framework".

Reply to this Message

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

Free Magazines