Replication

Hi all:

I am new to Mobile Data Bases. I am using mobile data base 2005. I want to transfer the data from the mobile DB to to the sql 2000 server DB. Presently i am using RDA where i am having a problem when the new records got inserted when the mobile and

sql 2000 server. I saw this as a limitation for the RDA. Will any one suggest me the better option for transfering the data from my mobile database to sql 2000.

I also want to if i used Merge replication, do i need to connect my device always to the internet or when ever i calls syncranize method it will automatically updates both the mobile and sql 2000 database.

Thanks in advance.

Vamsi.

Merge replication will work both ways "off-line", so that when you Synchronize both device and server changes will be synchronized. Be sure to filter your merge publication by userid or similar to avoid conflicts.|||

Thanks for your help ErikEJ.

Will you suggest which will be preferable RDA or Merge Replication for the following process.

I need to pick some columns from a table to client DB. where the client will make the changes. After making the changes they need to update the changes back to the server and clean the client DB.

Thanks

Vamsi

|||

For this process (I do not know all the gritty details, of course) I would suggest the following solution:

Merge Replciation - Use 2 tables, one for the data to be changed (could be filtered on the publication by user and/or date), and another for the changes. You can make this other one an "upload only" table by setting a filter like: "WHERE 1 = 0" on the publication.

Hope this makes sense.

|||

When i am using Merge Repliaction i had the problem when i am taking some columns from the Master table into the client and when i am trying to update an existing record ( record fetched from the master). in the client and tried Synchronize with Master.

The merge process could not enumerate changes at the 'Subscriber'. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200999)

Any one suggest how to over this problem.

In the remaining cases (like insert, delete) my application is working fine.

Thanks

Vamsi

|||Are you only taking some columns from the Master table? Make sure to include the primary key column(s).|||

thanks for your message.

I included Primary key.

The columns that i omitted for replication will allow nulls, even tough i am getting the same error.

The Master database that i am using for reliaction is sql server 2000 and the mobile data base is sql server 2005 mobile database.

Thanks

Vamsi.