Thursday, March 8, 2012

Copy data from SQL Server to SQL Mobile

Hello

I'm developing an application that need to create everyday information to be stored in a SQL Mobile Database.

The SQL Mobile database will have:

Last schema from tables (in SQL Server database);

Last information in the tables;

I don't want to copy all the tables from SQL Server database than this mecanism should give me the way to choose the tables.

I have been reading about the SqlCeReplication but I don't undestand what is InternetUrl property. The SQL Mobile database is created in the PC and after is copy to the the Mobile Device.
How can I avoid the InternetURL property?

tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal

Olá Paulo,

The Merge Replication process is based on an agent running on a DLL on IIS, so that's why you need the InternetURL property.

You may also consider the tools from www.primeworks-mobile.com which avoid IIS and may be used over TCP/IP or ActiveSync (RAPI). BTW, these tools are developed very close from where you live...

If you prefer to follow this in Portuguese, try the microsoft.public.pt.pocketpc newsgroup

Alberto Silva
http://msmvps.com/AlbertoSilva

No comments:

Post a Comment