473,326 Members | 2,655 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

SQL single file database

1
Hi everyone,

Wondering if there is such a thing as a single file SQL database i can use for my C# applications. Normally I would whack a copy of SQL Express on a machine for my own stuff, but thats way to chunky for distribution to the public.

So if anyone has any ideas, id love to hear them, and whilst I could use a Access Database file, access is crap and i'd rather not :D

Thanks


Xavier
Sep 19 '07 #1
2 2739
davef
98
No. In SQL Server, any database comprises of at least two files: Data file (*.mdf) and Log file (*.ldf).
Refer to the primer below:
A primer on SQL Server database files
Sep 19 '07 #2
azimmer
200 Expert 100+
Hi everyone,

Wondering if there is such a thing as a single file SQL database i can use for my C# applications. Normally I would whack a copy of SQL Express on a machine for my own stuff, but thats way to chunky for distribution to the public.

So if anyone has any ideas, id love to hear them, and whilst I could use a Access Database file, access is crap and i'd rather not :D

Thanks


Xavier
Take a look at SQLite (www.sqlite.org); it's really good. I've used it several times from TCL and C; I don't know how it aligns with C#, though.
Sep 19 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: googlinggoogler | last post by:
Hiya, The title says it all really, but im a newbie to python sort of. I can read in files and write files no probs. But what I want to do is read in a couple of files and output them to one...
10
by: Bing Du | last post by:
Greetings, Our former SQL Server 2000 DBA backed up everything in a single disk file. By everything I mean, full backup, differential backup and transaction logs. See below for details of how...
2
by: Connected | last post by:
Hi, Using VS.NET 2003, I would like to deploy my project as a single-file exe. What I actually get is three files: Setup.exe Setup.ini MyProg.msi
0
by: johnb41 | last post by:
The heart of my application is a database (MS Jet, SQL, etc.). The user needs a connection to this database before he/she can do anything w/ the program. The user will also work with supplimental...
1
by: Gene Kahn | last post by:
Hello, How do single-file databases do it? If a database has, say, 10 tables, does that mean that the single-file is just a trick to hold ten separate 'boxes' inside, one for each table, or...
13
by: Kevin Walzer | last post by:
Which of the Windows/Unix package builders for Python applications is capable of creating single-file executables? I'm thinking of: 1. py2exe 2. Mcmillan Installer/PyInstaller 3. cxfreeze ...
6
by: kumar_anil_gaya_India | last post by:
Hi All, I am facing one problem. I have one DLL called LogManagement which has ability to write to ExceptionLog and EventLog File. Both are separate file locate in Logs Diectory. I have two ...
35
by: keerthyragavendran | last post by:
hi i'm downloading a single file using multiple threads... how can i specify a particular range of bytes alone from a single large file... for example say if i need only bytes ranging from...
5
by: =?Utf-8?B?anAybXNmdA==?= | last post by:
Using Visual Studio 2005 and C#, is there a way to create a single file executable out of my project? We have made database tools that our employees use out on the manufacturing floor, and the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.