Search code examples
databasems-accessmigrationsql-server-cedatabase-migration

Migrate Microsoft Access Database to SQL Server Compact Edtion 4.0

I have created an application that uses a Microsoft Access database, which I am having some issues with and so want to migrate to Microsoft SQL Server Compact Edition.

I have looked into several tools but I can't find anything currently around that would convert the Access database to SQL CE. Does anyone have any advice for re-creating the tables quickly or links to software tools that I could use? Ideally a free solution, or pretty cheap (>£50?)

I have tried:

  • Microsoft SSMA - This tool supports every version of SQL server except the compact edition.
  • Primeworks - The link to download the tool is now dead
Solution

  • 1: Use SSMA to migrate from Access to a free SQL Server edition (LocalDB / Express)

    2: In Visual Studio 2015 Community Edition (also free), use my free "SQL Server Compact Toolbox" to migrate from the SQL Server database to SQL Compact (either via "one-click" or via scripts)