Showing posts with label tools. Show all posts
Showing posts with label tools. Show all posts

Sunday, 11 March 2012

Connect from sqlce 2.0 to sql server 2005

I want to connect sqlce 2.0 to sql server 2005. From "Connectivity Tools for SQL Server Compact, SQL Server Mobile, SQL Server 2000, and SQL Server 2005", I know I should install sql server 2005 without the replication components. I do it, then i find i can not create publication. Without replication, how can i synchronize between sqlce 2.0 and sql server2005?

Anyone can help me?

Thirst for your answer.

Anyone can tell me how to synchronize between sqlce 2.0 and sqlserver2005 in detail?

Friday, 24 February 2012

Conflict Management

Hello:
If merge replication uses anonymous pull subscriptions and
the subscribers have no sql server tools installed, how can the
subscribers resolve conflicts? (Can we provide a program interface to
help do this?)
Does replication(merge) preserve transactional integrity
while doing updates to the publisher, if there is a conflict. (That
is, if a updated table, that was updated in a transaction on a
replicated database, conflicts with another replicated database, since
this information waits in conflict tables till resolved, will the
whole transaction wait or will the remaining tables proceed to update
themselves?)
Thanks for the help,
Hananiel
The conflict viewer is one possibility. I believe this ships with Office
2003. The SQL 2000 Resource kit has a chapter devoted to the Conflict
Resolver object. You might want to build your own conflict resolver app.
"Hananiel" <hananiel@.yahoo.com> wrote in message
news:e338e321.0410110813.771d55a8@.posting.google.c om...
> Hello:
> If merge replication uses anonymous pull subscriptions and
> the subscribers have no sql server tools installed, how can the
> subscribers resolve conflicts? (Can we provide a program interface to
> help do this?)
> Does replication(merge) preserve transactional integrity
> while doing updates to the publisher, if there is a conflict. (That
> is, if a updated table, that was updated in a transaction on a
> replicated database, conflicts with another replicated database, since
> this information waits in conflict tables till resolved, will the
> whole transaction wait or will the remaining tables proceed to update
> themselves?)
> Thanks for the help,
> Hananiel