Re: Struggling with Mobile Development

Tech-Archive recommends: Speed Up your PC by fixing your registry

John,

You can get the definitive book on replication here: http://blogs.msdn.com/robtiffany/

You can also find a nice sample here: http://www.microsoft.com/downloads/details.aspx?FamilyId=80A5C2C5-4F9B-4C1A-BFF6-2A3C6B68D15B&displaylang=en

Also keep an eye on this space for more sync options: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1225&SiteID=1 (Sync with mobile devices is not currently supported by Sync Services, but it is under development.)

And finally, you can write your own desktop application that can connect to SQL Server and build a SQL Compact database for use on a mobile device using the SqlClient and SqlServerCe namespaces for managed development or OleDb for unmanaged.

--
Ginny Caughey
Device Application Development MVP


<ibidibi411@xxxxxxxxxxx> wrote in message news:9563f68b-e2aa-4ddc-9893-d019c60fa31b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I am to begin developing CE database applications that are going to
need direct connectivity to a full SQL Sever database or at least
*seem* like they are directly connected. I am thinking that SQLServer/
CE is the logical way to proceed, but how do I get the data from
the .sdf file into the SQL Sever? I've seen some stuff about using
replication, but that seems pretty difficult and I don't know where to
find sample code for this. I have been able to connect the
application's controls to an SDF file, but how do I get the data from
the SDF into the actual server??

Thanks,

John

.

Relevant Pages

  • Re: How to create .SDF file programmatically on the server for MR
    ... an initial state of the local database that you can use anywhere SQL Compact ... get updated periodically through merge replication. ... course, if your database is download-only, you could download a new version ... application to download a compressed version of the .SDF file through ...
    (microsoft.public.sqlserver.ce)
  • Re: How to create .SDF file programmatically on the server for MR
    ... it should be very simple to generate your *starting point* database on ... an initial state of the local database that you can use anywhere SQL Compact ... get updated periodically through merge replication. ... application to download a compressed version of the .SDF file through ...
    (microsoft.public.sqlserver.ce)
  • Updating local SDF (in VS2005) to match updated merge replicated tables...
    ... I am relatively new to this Merge Replication game. ... the principles involved in the replication and how to set it up. ... Say I change/add a new column or table in my Publisher database. ... have to manually add the new SDF file? ...
    (microsoft.public.sqlserver.replication)
  • Cannot open user default database. Login failed when login with group id
    ... I got the following error when logon the SQL Sever. ... "Cannot open user default database. ... And then I could login the SQL sever. ... I changed default database with window domain group id using sp_defaultdb, but the user in the group id cannot login the SQL server. ...
    (microsoft.public.sqlserver.connect)
  • Re: filling listbox from table
    ... I missed capitalizing a letter in the field name of the new database. ... I think I got the tables and indexes created on SQL Sever 2000 just like they were in SQL Express 2005. ... REM read/sort key words ... REM add keywords to listbox ...
    (microsoft.public.dotnet.languages.vb)