i am using windows mobile 5.0 .Now iam downloading the total database from remote system using synchronization.but it is a huge database.so i want to download only some part of the databse.i.e in employee table somany employees will be there.from there i want to download only one employees data from that database.
Can we do this using synchronization concept.Here i want to use XML schema.That XML file will be downloaded into the PDA and will be converted to SQLCE.And while uploading the XML file will be uploaded and the data will be stored into the SQLSERVER of the remote system.
Can anyone give me guidance in this issue sothat iam very greatful to them.
If you are using merge replication and you are pulling the entire publication to the mobile device, you might want to simply put some filters in place. you can establish horizontal or vertical filters on your publication so that only certain rows or columns in the publication propagate to the SQL CE or SQL Mobile database.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replperf_5kx1.asp
If you want to use XML instead, you might review the 4 new Northwind sample apps such as
http://msdn.microsoft.com/library/en-us/dnppcgen/html/nw_pocket_analyze_decision_support_wm2k3_sp.asp?frame=true&_r=1
many of which use XML as a mechanism of data synchronization with SQL CE on device.
-Darren
No comments:
Post a Comment