locked
Migrating from SQL Server Express to SQL Server Compact RRS feed

  • Question

  • User78124615 posted

    We are developing a web application using ASP.NET MVC; we have created Identity module using MVC Identity model in this link, which uses SQL Server Express. Right now, we want to use SQL Server compact instead of SQL Server Express, is there any suggestions about how we can migrate smoothly to SQL Server Compact? We are using this model for most of the tools in the application to grant permissions and privileges for users/roles and want to migrate without affecting functionality of the application tools and functions

    Any Help is highly appreciated,

    Kind Regards,

    Monday, March 19, 2018 4:23 PM

All replies

  • User1120430333 posted

    It's where you can post.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlexpress

    It is kind of questionable about going from Express to Compact for a Web based solution, when that is not what Compact was designed for in usage.

    https://en.wikipedia.org/wiki/SQL_Server_Compact

    <copied>

    Microsoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops. Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile Edition.

    <end>

    http://erikej.blogspot.com/2011/01/comparison-of-sql-server-compact-4-and.html

    Monday, March 19, 2018 6:46 PM
  • User78124615 posted

    Thanks for the redirection!

    Tuesday, March 20, 2018 10:48 AM