SQL Server 2k5 mobile for my PDA Application

• Agile

  Ten Centuries

  Points: 1153

  More actions

  December 18, 2009 at 10:50 pm

  #207652

  Hi guys, Im a newbie in SQL mobile, i have 2 questions, hoping that someone can give me assistance.

  1. Im planning to develop .net application for my PDA, So Im planning to install SQL Mobile Edition 2005 to my PDA, this is the exact file Is it right? I mean the type of sql server that I need to install?

  2.If Im right on my no.1 question, Is there a way I can sync my SQL Mobile data to Sql server Enterprise automatically?, I mean every 30mins the data from my sql mobile will sync to sql server enterprise, Is it possible. If there is, Where can I do that, in sql mobile settings or in SQL SErver Enterpise? or perhaps someone can give link to where I can get that info.

  Thank you in advance.

  Thanks,
  Morris

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  December 19, 2009 at 12:35 pm

  #1094477

  Here is existing article from Microsoft that will help you create replication with SQL Server CE.

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

  Kind regards,
  Gift Peddie

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734449

  More actions

  December 19, 2009 at 12:54 pm

  #1094480

  Yes you can sync up and you'll want SQL Server Compact Edition.

  there's a sync framework to check out: http://msdn.microsoft.com/en-us/sync/default.aspx

  and compact edition is here: http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx