28549Integrity Violation when sync between PDA and SQL server 20

Hi all,
I have a problem with replication. I did a search for error number 28549 in
this group and find no answer that matched my case. :-(
I have used replication for download data from sqlserver to pda. All the
tables a independent with each other. No link between them.
I have set the -ExchangeType 2 so that the synchronization is just one
direction from sql server to pda.
There aren't null data.
I have 50 users synchronize data. Some of users succeeded but most of them
failed.
The error is 28549-Integrity Violation...
I tried to copy the data file (.sdf) from pda of user succeeded in
synchronization. And then paste it to a new pda, synchronize again, and
that's so odd!!!! I met the same error!!!
I was confused, Can anyone help me out...
So appreciated
I have found that server have insert some rows that existing in
subscriptions. How can I find which row is conflict with db at subscriptions
at merge-agents. or at db server.
I have tried to delete merge_contents table, and it seems after that, all
subscriptions can not be regconized. All subscriptions are anonymous
subscriptions
"Mai Thoa" wrote:

> Hi all,
> I have a problem with replication. I did a search for error number 28549 in
> this group and find no answer that matched my case. :-(
> I have used replication for download data from sqlserver to pda. All the
> tables a independent with each other. No link between them.
> I have set the -ExchangeType 2 so that the synchronization is just one
> direction from sql server to pda.
> There aren't null data.
> I have 50 users synchronize data. Some of users succeeded but most of them
> failed.
> The error is 28549-Integrity Violation...
> I tried to copy the data file (.sdf) from pda of user succeeded in
> synchronization. And then paste it to a new pda, synchronize again, and
> that's so odd!!!! I met the same error!!!
> I was confused, Can anyone help me out...
> So appreciated
|||Please provide more detail about your setup, like, version of sql server,
kind of replication (replication over VPN or web sync using https), and in
which replication process are you getting this error?
thansk - Deepak
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Mai Thoa" <MaiThoa@.discussions.microsoft.com> wrote in message
news:09DF1BD7-55D6-473A-9FA0-BEA8B021603F@.microsoft.com...
> I have found that server have insert some rows that existing in
> subscriptions. How can I find which row is conflict with db at
subscriptions[vbcol=seagreen]
> at merge-agents. or at db server.
> I have tried to delete merge_contents table, and it seems after that, all
> subscriptions can not be regconized. All subscriptions are anonymous
> subscriptions
> "Mai Thoa" wrote:
in[vbcol=seagreen]
them[vbcol=seagreen]

2005 Express Sync

Hi,
Is there any way to keep 2 SQL 2005 Express instances in Synch. I know that
SQL 2005 Express doesn't support Replication between them. What other
options do I have without upgrading to SQL 2005 Server. Any 3rd party
application or options with in 2005.
One of the SQL 2005 Express will be the "Master" and I will like to sych or
send the new that two the seconds instance. There is not update or deletes
to this database it will only have new inserts.
Thanks
Julio D
I expect that the new ADO.NET Synchronization Services API might be of some
use. It can be used between SQL Express instances (as well as other data
sources) to keep database tables in sync.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...
------
Microsoft MVP, Author, Mentor
Microsoft MVP
"Julio Delgado" <jdelgado89@.hotmail.com> wrote in message
news:OeKG$SDgHHA.1216@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Is there any way to keep 2 SQL 2005 Express instances in Synch. I know
> that SQL 2005 Express doesn't support Replication between them. What other
> options do I have without upgrading to SQL 2005 Server. Any 3rd party
> application or options with in 2005.
> One of the SQL 2005 Express will be the "Master" and I will like to sych
> or send the new that two the seconds instance. There is not update or
> deletes to this database it will only have new inserts.
> Thanks
> Julio D
>
|||Bill, thanks for the info, do you know of another tool since I need it for a
current application that we have.
Thanks
Julio
"William (Bill) Vaughn" <billva@.NoSpamAtAll_betav.com> wrote in message
news:O$RHGRGgHHA.1244@.TK2MSFTNGP04.phx.gbl...
>I expect that the new ADO.NET Synchronization Services API might be of some
>use. It can be used between SQL Express instances (as well as other data
>sources) to keep database tables in sync.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> Between now and Nov. 6th 2006 you can sign up for a substantial discount.
> Look for the "Early Bird" discount checkbox on the registration form...
> ------
>
> Microsoft MVP, Author, Mentor
> Microsoft MVP
> "Julio Delgado" <jdelgado89@.hotmail.com> wrote in message
> news:OeKG$SDgHHA.1216@.TK2MSFTNGP03.phx.gbl...
>
|||I think it would be a waste of time to reinvent the wheel being created with
Synchronization Services. It's available now in CTP form. Yes, it's likely
to change between now and when it ships this fall, but it should solve your
problem.
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest books:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
Hitchhiker's Guide to SQL Server 2005 Compact Edition
------
"Julio Delgado" <jdelgado89@.hotmail.com> wrote in message
news:uoHXfnTgHHA.4916@.TK2MSFTNGP06.phx.gbl...
> Bill, thanks for the info, do you know of another tool since I need it for
> a current application that we have.
> Thanks
> Julio
> "William (Bill) Vaughn" <billva@.NoSpamAtAll_betav.com> wrote in message
> news:O$RHGRGgHHA.1244@.TK2MSFTNGP04.phx.gbl...
>
|||friggin fabulous info, thanks!
I really really hate how they crippled MSDE 3.0
lol
"William (Bill) Vaughn" <billva@.NoSpamAtAll_betav.com> wrote in message
news:O$RHGRGgHHA.1244@.TK2MSFTNGP04.phx.gbl...
> I expect that the new ADO.NET Synchronization Services API might be of
some
> use. It can be used between SQL Express instances (as well as other data
> sources) to keep database tables in sync.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> Between now and Nov. 6th 2006 you can sign up for a substantial discount.
> Look for the "Early Bird" discount checkbox on the registration form...
> ----
---[vbcol=seagreen]
>
> Microsoft MVP, Author, Mentor
> Microsoft MVP
> "Julio Delgado" <jdelgado89@.hotmail.com> wrote in message
> news:OeKG$SDgHHA.1216@.TK2MSFTNGP03.phx.gbl...
other
>
|||So use SQL Server Express Edition. Frankly, I've never (as in never) seen a
documented case where the governor was the root cause of a performance
problem with MSDE.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Aaron Kempf" <akempf@.dol.wa.gov> wrote in message
news:uMyRgCCjHHA.3928@.TK2MSFTNGP03.phx.gbl...
> friggin fabulous info, thanks!
> I really really hate how they crippled MSDE 3.0
>
> lol
>
> "William (Bill) Vaughn" <billva@.NoSpamAtAll_betav.com> wrote in message
> news:O$RHGRGgHHA.1244@.TK2MSFTNGP04.phx.gbl...
> some
> rights.
> other
>