Questions about Sql CE 3.1

Discussion in 'microsoft.public.sqlserver.ce' started by FACE ONE, Oct 23, 2009.

  1. FACE ONE

    FACE ONE Guest

    Hi,

    i have two questions about SqlCE 3.1

    I make a VB.NET software for .NET 2.0 with JET (Access 2003) database.

    Now i want to use Sql CE 3.1

    Questions:
    1) It's possibile to use SQLCE3.1 in a LAN ?
    i want to use (from my pc) a db into an other pc folder share

    2) it's possible to port Access DB into a SQL CE ?

    Thank you

    FACE ONE
     
    FACE ONE, Oct 23, 2009
    #1
    1. Advertisements

  2. FACE ONE

    ErikEJ Guest

    Only a single PC at the time can connect to a SQL Compact database. The
    dabase can be located on a LAN drive.

    www.primeworks-mobile.com provides some good tools to convert from Access to
    SQL Compact.
     
    ErikEJ, Oct 25, 2009
    #2
    1. Advertisements

  3. FACE ONE

    FACE ONE Guest

    Hi ErikEJ,
    thanks for the reply and the link.

    Use SQLCE locally (instead MDB) and SQL Express on the server might be a
    good idea?

    The sqlce is only for work locally with a copy of db.

    Can i synchronize CE 3.1 and express 2005 using replication?

    Thank you

    FACE ONE
     
    FACE ONE, Oct 25, 2009
    #3
  4. FACE ONE

    ErikEJ Guest

    You can use RDA or ADO.NET Sync Framework to synchronize, yes.
     
    ErikEJ, Oct 25, 2009
    #4
  5. FACE ONE

    FACE ONE Guest

    Hi ErikEJ,
    Thank You for reply

    FACEONE
     
    FACE ONE, Oct 26, 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.