Discussion in 'microsoft.public.sqlserver.ce' started by ing. ignazio pinto, Oct 26, 2009.

  1. How can i convert a sql server database to a sql server compact database?

    ing. ignazio pinto, Oct 26, 2009
    1. Advertisements

  2. You can't, directly. You could, potentially, use remote data access from a
    program designed for this purpose, to query all of the data in the SQL Server
    database and create the same structure and data in your Compact database. I
    guess that you might be able to get the SQL statements from the server
    database and run those against your Compact database. Of course, there are
    many things that Server can do that Compact can't, so there are going to be
    potential problems.

    You also might do this via merge replication of the Compact database with
    the Server database, especially if you need to continue keeping the two
    databases and keeping them synchronized.

    I think that, if you give us a clearer description of what you trying to do
    (why are you doing this? what's the application of this 'converted' data?
    do they need to both exist and continue to be synchronized?), we might be
    able to give you some better recommendations.

    Paul T.
    Paul G. Tobey [eMVP], Oct 26, 2009
    1. Advertisements

  3. Russell Fields, Oct 26, 2009
  4. ing. ignazio pinto, Oct 30, 2009
    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.