2-way Merge Replication(PDA<->SqlServer2000)

I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.

The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.

The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overwrite the records in PDA. My requirement is to not overrite the records but it should update the existing table.

Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.

Move to Sql Server Compact Edition. Thanks!

Zero Dai - MSFT

|||You must move the initial data to the server tables, or add initial data in code on the PDA after the first sync.|||

Hi all,

Thanks for the reply and Sorry for the delay.I have a new problem that,I alredy mentioned you i am using Sql Server 2000 as publisher.....In that i alreay Configured one Databse as Publisher....it is working fine and now i want to use another database as a publisher in the same server........the problem is this time it is not asking for Snapshot location while publishing the Database

Once we mentioned it is sufficient or wat to do.........to get Snapshot.exe file........I am assumed that the previous snapshot is sufficient and synchronized bt giving DB name and publisher name...But it is giving Native error:29061.

Another thing i did was,I disabled the Database as Publisher and try to publish from the first.This time it is asking for snapshot location but in that location it is not creating any snapshot.exe.......and not even Snapshot folder.wat to do.plz help meeeeeeeeeeeeeee.......

Thanks And Regards

Ayyappa.k

2-way Merge Replication(PDA<->SqlServer2000)

I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.

The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.

The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overwrite the records in PDA. My requirement is to not overrite the records but it should update the existing table.

Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.

Move to Sql Server Compact Edition. Thanks!

Zero Dai - MSFT

|||You must move the initial data to the server tables, or add initial data in code on the PDA after the first sync.|||

Hi all,

Thanks for the reply and Sorry for the delay.I have a new problem that,I alredy mentioned you i am using Sql Server 2000 as publisher.....In that i alreay Configured one Databse as Publisher....it is working fine and now i want to use another database as a publisher in the same server........the problem is this time it is not asking for Snapshot location while publishing the Database

Once we mentioned it is sufficient or wat to do.........to get Snapshot.exe file........I am assumed that the previous snapshot is sufficient and synchronized bt giving DB name and publisher name...But it is giving Native error:29061.

Another thing i did was,I disabled the Database as Publisher and try to publish from the first.This time it is asking for snapshot location but in that location it is not creating any snapshot.exe.......and not even Snapshot folder.wat to do.plz help meeeeeeeeeeeeeee.......

Thanks And Regards

Ayyappa.k

2006/06/26 15:49:32 Hr=80004005 ERR:OpenDB failed getting pub version 28627

Dear Sirs. I Have a Pc were i have made the development, where i have sql 2005, sql server mobile etc. I have made a program with a merge replication. It works fine on lan using wireless. I have maped a public ip address opened the tcp 80 port and doing nat to the pc. I able to do the http://xxx.xxx.xxx.xxx/aaaaaaa/sqlcesa30.dll, it ask for authentication, and after display's the "sql server mobile server agent 3.0". but when i ran the aplication (it sync's ok on a wireless lan, only changing the ip address to the public address) it apears : Failure to connect to SQL Server with provided connection information. SQL Server4 does not exist, access is denied because the IIS user is not a valid user on the SQL server, or the password is incorrect"

Thanks .

Paulo Costa

Is this public IP a different machine? If so, it authenticaion mode needs to be set and your application needs to use that approprate authentication mode. Additionally the credentials you use in your application need to be trusted and/or validated by this IIS machine. Please verify that you are doing this and reply back if you still have issues.

2005 BoL

Hi

Why is it when I search BoL or click on links on the index I keep getting SQL Server Mobile help pages rather than (for example) the Transact SQL help pages that I want. I can usually find a link at the bottom of the page but is there any way to filter this stuff out in the first place?

Ta!where are you searching? google? msdn? or BOL on your own computer?|||BoL on my pc|||For example - ALTER TABLE in the index - I get a link that, when clicked, takes me to ALTER TABLE (SQL Server Mobile). Down the bottom there is a link to ALTER TABLE (Transact SQL). I want that one first :)|||Ok - filter by database engine rather than SQL Server 2005 and I don't appear to get the mobile stuff. Not sure what else I might lose too though...|||maybe this will help:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=647689&SiteID=1|||Jezemine - thank you. Another concise and accurate post :)

Out of curiosity, did you know about that already or (to my shame) did you just google because I did not find that one... :o

Anyway - will try in work tomoz.|||i had a vague recollection of seeing the post, but I didn't have the link memorized. ;)

so I resorted to google.

fyi, here's the search I did: http://www.google.com/search?q=remove+mobile+from+bol|||fyi, here's the search I did: http://www.google.com/search?q=remove+mobile+from+bolOh....





Dear :o

N00bie Poots|||see what you get for http://www.google.com/search?q=turn+off+activex and http://www.google.com/search?q=turn+off+javascript

;)|||Forgive my ignorance - what is the relationship?|||nothing, it's just that i happened to somehow end up as #1 or #2 on the search results for both those queries, when you'd think a microsoft page might come up ahead of me

or maybe not

sorry for the dissonance|||Lol - I read the culminated-in-the-SQL-Consultant-moniker article some time ago.
Are you just showing off?

Anyway - ActiveX settings checked and they are OFF OFF OFF :D

BTW - familiar with cognitive dissonance - curiously never come across it before without the cognitive bit.|||Are you just showing off?ah caint hep it!!