best way to use sqlserver mobile vr pc

[jason78944545]

hi,
i need add a sqlserver in a mobile device to store data from the mobile app and for send to the sqlserver pc the same data for sincronize the information there is any sqlserver for a mobile device for free?
here can i get more information about this?
my objective is store information pc vr mobile in a sqlserver database
thanks for your help
:)

[jmcilhinney]

http://www.microsoft.com/sqlserver/2005/en/us/compact.aspx

[Lightning]

If that mobile device has a networkconnection (wifi,USB with activesync, GRPS, UMTS) you could simple create a connection to the server that is running the SQL service.

Be sure to check for a valid connection

And I believe MSSQL 2008 has serveral tools for just this purpose, including datasyncronisation
MSDN blog (http://www.google.nl/url?q=http://blogs.msdn.com/sync/archive/2008/06/24/sample-sql-express-client-synchronization-using-sync-services-for-ado-net.aspx&sa=X&oi=revisions_result&resnum=2&ct=result&cd=1&usg=AFQjCNGsChBm_JGdqwPish4Ur3KkzPw2FA)

[gep13]

Hey,

In addition to what has been set here, it is possible to use a technique called Merge Replication between SQL Server Compact Edition and a full SQL Server Instance. That means, that any changes made to the database of the Mobile Device are automatically sent up to the SQL Server Instance, and vice versa.

There are several articles about this, here is one:

http://msdn.microsoft.com/en-us/library/ms172367.aspx

And I am fairly sure that this series of web casts contains a video that contains step by step guide on how to step Merge Replication up:

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032287179&EventCategory=5&culture=en-US&CountryCode=US

Hope this helps!!

Gary