Unanswered: Upsizing From MS Access To SQL Server Compact Edition
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.
- Bulllzip utility (free and very good)) Access To MSSQL http://www.bullzip.com/products/a2s/info.php
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)