Development environment for SQL CE 3.5?

Discussion in 'microsoft.public.sqlserver.ce' started by Thomas Steinmaurer, Mar 27, 2009.

  1. Hello,

    pretty basic questions for you guys ...

    I want to develop only the SQL CE 3.5 database portion of an application
    for a Windows CE 6.0 device.

    * Can I create the database on my Windows XP with SQL CE 3.5 installed
    and then let the application developer use this database for developing
    and deploying?
    * What does the application developer need to access a SQL CE 3.5 via a
    ..NET application for both, desktop and Windows CE device?
    * Can I use SQL Management Studio Express 2005 for developing SQL CE 3.5
    databases or do I need Management Studio Express 2008?
    * Are desktop CE database files binary compatible between the desktop
    and the Win CE 6 device for both, unencrypted and encrypted database files?
    * Is there a tool to dump a SQL CE 3.5 database file into a sequence of
    SQL statements which can be used for versioning, re-creating the
    database, ...


    Thanks
    Thomas
     
    Thomas Steinmaurer, Mar 27, 2009
    #1
    1. Advertisements

  2. Thomas Steinmaurer

    ErikEJ Guest

    Hi Thomas,
    Yes, but beware of the locale id used when creating the database, a reindex
    may occur if they differ from desktop to device
    I am not sure what you mean by this question, in order to develop for
    devices with SQL CE 3.5 you need Visual Studio 2008 Pro or higher.
    For SQL Compact 3.5 SP1, you need Visual Studio 2008 Express SP1
    Yes, I host such a free tool here: http://exportsqlce.codeplex.com/
     
    ErikEJ, Mar 27, 2009
    #2
    1. Advertisements

  3. Hi Erik,
    May occur automatically? Or do I have to do something here?

    Ok. Thanks.
    VS 2008? Well, I was able to work with a CE 3.5 database with Management
    Studio Express 2008.
    Works like a treat. Thanks!


    Regards,
    Thomas
     
    Thomas Steinmaurer, Apr 29, 2009
    #3
  4. Thomas,

    To answer your question, the reindex caused by a different local id is
    automatic, but you may notice decreased performance while this happens the
    first time the database is opened.
     
    Ginny Caughey MVP, Apr 29, 2009
    #4
  5. Hi!
    Ok. Thanks! As the initial deployment of the database only includes a
    few records, this won't be an issue then.

    Thanks for the follow up.

    Regards,
    Thomas
     
    Thomas Steinmaurer, Apr 29, 2009
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.