Re: SQL Server Express - Detach & Shrink

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

William (Bill) Vaughn wrote:
Ah, now _I_ am confused.

OK, what I need is some sort of single file to store numerical data. In the
past we have used Access databases for this sort of thing but now our client
is storing up to millions of rows of data in a single file and Access just
can't cope with this. During each session he may want to remove some of the
data and add some more.

After a few tests I found that SQL Server Express can handle this amount of
data quite well and as you said it can be used for a single user locally on
a system. Our client requires that these files be portable for e-mailing,
copying to CD or sending via FTP (depending on how big they are) etc. The
only trouble is that an SQL Server Databases (mdf) also require that the log
file (ldf) is moved around with it.

So when a user has finished with a database, I stream both the mdf and ldf
files into a single file that the user can treat like any other file. When
that file is opened again, my application extracts the mdf and ldf and puts
it into a temporary folder for access again.

This way I get the practical, scalability and speed benefits of teh SSE
database along with the requirement that the uesr has of having a single
project file. The extraction and combining of the mdf & ldf are pretty quick
and the whole process seems to work very well. Creating our own system for
storing the data in a way that gives me as much functionality just seems to
be re-inventing the wheel!

I hope this makes sense and although it seems to work very well I'd be
interested in any flaws that you can think of.


.

Relevant Pages

  • Re: SQL Server Express - Detach & Shrink
    ... BCP can be invoked from SQL Server itself to export the file. ... what I need is some sort of single file to store numerical data. ... So when a user has finished with a database, I stream both the mdf and ldf ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: My own primitive database
    ... Its one of the those single file non-server databases. ... a PostgreSQL or MySQL or similiar "real" databases. ... If this is a one time school/lab project then I would just use SQLite ...
    (comp.lang.java.programmer)
  • VLDB and Transaction Log
    ... We have large databases in the range of 40-80 GB. ... The transaction logs are ... spindle or multiple smaller files each on their own spindle. ... The documentation I have read in the past pointed to a single file, ...
    (microsoft.public.sqlserver.setup)
  • Reverse Engineering.............Ooooooooohhhhhhhh
    ... I am trying to figure out a DAO connection to an unknown database ... I have an app that uses single file 'databases', ... install process for this application DAO3.5 is installed - presumably ...
    (comp.databases.ms-access)
  • Re: Reverse Engineering.............Ooooooooohhhhhhhh
    ... I am trying to figure out a DAO connection to an unknown database ... I have an app that uses single file 'databases', ... install process for this application DAO3.5 is installed - presumably ...
    (comp.databases.ms-access)