move database created in localdb to SQL Server Compact


  • I have created a database in entity framework for an application using localdb.  I would like to copy this database to SQL Server Compact 4.0 when I deploy the application.  I have been researching but haven't found any information regarding this.  Would anyone know if this is something I can do? 
    Monday, April 07, 2014 1:28 AM


  • You should also convert during developement, as the SQL syntax may not be 100% compatible.

    You can use my SQL CE Toolbox to convert the SQL Server database to a SQL Compact database, and you may have to change code and/or edmx file, depending on which workflow you use (you have not told us)

    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    • Marked as answer by rsargent Tuesday, April 15, 2014 3:28 AM
    Monday, April 07, 2014 7:24 AM