Need Help !! RDA replication

Hi Everyone:

I am new to Mobile programming. I am now working on a mobile project. I encounter an issue when I sync the data:

cause I can't modify the schema, so I have to use RDA instead of Merge replication on sql server 2005.

However, There is an identiy column on each table I will pull them down to local mobile database. And I will use those identity columns to connect tables. Even worse, the photo's new name will combine the photoID which is an identity column. There would an issue, if i sync data, the photoID would be same on different local mobile databases. And there would be generate same identity value when users sync data.

How can I avoid those issues? If you have any good ideas, please help me out so that I can meet the project deadline.

Thanks

James

I dont understand the problem.

Are you having issues with the identity column or changing the schema?

If it is identity management, Merge replication supports out of the box identity management.

|||

hi,

Thank you for your reply. I can't change the DB schema, that's why I abandon the merged replication, cause it will add one Rowguid column in. It will hurt the existing application.

I am chosing RDA instead. I have solved this issue.

Thank you.

James