EVE Technology Lab

Greetings

I would like to convert the MSSQL DB to a non server style DB; that is to say I would simply like to work with a disconnected, lightweight blob of data comprised of tables and data

I do not need all of the relational overhead that comes with classic databases, nor do I need the server style architecture common with most databases.

I also want to avoid having to rely on a layers of dependencies should I share the application with another user. Other than the the normal DOT NET dependencies, I am looking for a solution that is simply a copy and paste a few files to share the application....no installer required

I am simply looking for the tables and the data in a single file that I can access using objects and Linq in C# NET 3.5

Can anyone suggest what I should convert the MSSQL format into to achieve this?

I am looking for: Simple, Light, Fast, Portable

Thanks in advance

SR Hadden

Fantastic

I had begun probing around with CE but that looked to be problematic

Lite looks very promising...and is Open to boot

Any other suggestions still welcomed, while I learn of and play with SQLite

Hat tip to Desmont

SR Hadden

So I I went MSSQL.bak >>> MSSQL.dbf via SQL Server Mgt Studio using the tasks>restore utility....then used some source code off of Code Project : Code Project SQL Server to SQLite to get from the *.dbf to the *.db

It took a while but all worked well and I now have the eve db_Dump in SQLite sitting happily in my .NET project within VS IDE

Having probed around this sub-forum it looks as if conversions are always a bit of trouble....I suppose I should expect this sort of manual gymnastics when they update the dump each time?

Thanks again for the tip on SQLite

Regards

SR Hadden