CODEWITHSUNDEEP
sql-serverin-memory-databasecompact-database
Paul Fryer
Paul Fryer

Reputation: 9527

Is it possible to run SQL Server Compact Edition totally in memory?

I have a need to run a small database in memory (no disk). It's important that the data only be loaded in memory and not persisted on disk. I will load the database up when the application starts. The source database is SQL Server. Its a very small configuration database that I want to copy from the source into a memory-only database. I'm thinking SQL Server Compact edition might be a good fit here, but am not sure if that will write data to disk or if it can be configured to only run in memory. Hoping someone can shed some light on that.

Also, I realize there is a pagefile that will be on disk. However my main concern is data at rest. This means I don't want the database to be permanently stored on disk.

Upvotes: 0

Views: 921

Answers (0)

Related Questions