Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2014

    Unanswered: Upsizing From MS Access To SQL Server Compact Edition

    Hi Guys,

    Is there a way to upsize an Access Database to SQL Server Compact Edition? It's my understanding that it has a small footprint and is well suited for desktop applications and produces local database files. This seems like it's the right choice for the application that I'm working on. I would still like to be able to create views, basic stored procedures and functions.


  2. #2
    Join Date
    Jan 2014
    May be some ways, i.e.:

    - the Upsize Wizard from MS Access:
    How to convert an Access database to SQL Server

    - Bulllzip utility (free and very good))
    Access To MSSQL
    I used many times to migrate MDB to SQL Server 2008/2012 (but never used to migrate on CE, so I don't know if work for CE)

    - Data Port Wizard (old)
    The Primeworks Mobile Blog: Data Port Wizard is now FREE
    The donwload link isn't longer valid. so see the link to download from Google Drive Folder (right-side page)

    Searching on Google may produce more results.

  3. #3
    Join Date
    Apr 2004
    outside the rim
    There are a lot of tools and procedures to create objects in SQL from Access. Unless the database is big, tho, it's generally best to manually create the tables in the SQL DB and then move the data.
    have fun!

    Todd S.
    click to email

    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET

    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

  4. #4
    Join Date
    Sep 2014
    Thanks for the input guys, much appreciated. For now I have put the project on the shelf because of a query issue I cannot seem to resolve.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts