Re: Time to migrate from Access DB to???? ---- Need recommendations
- From: "Michel Posseth [MCP]" <MSDN@xxxxxxxxxxx>
- Date: Wed, 22 Aug 2007 21:12:33 +0200
Never heard of Firebird. Will have to look into it.
ever heard of interbase ? http://en.wikipedia.org/wiki/Interbase
Firebird is the conitinuance of the source from the once greatest
multiplatform database availlable at that time and even today a lot of
companys work with the commercial versions .
Borland made the source public , and so you have a few spinoffs , the best
spinoff is Firebird wich is actually , really a great datbase if costs oare
your concern
i just visited there website for the latset news and read there that it even
has now full VS.Net integration .
I have onced tested the DB engine for my previous employer , and we were
really impressed how good it performed and easy to use it was in
contradiction to other vendors ( who charged for all extras , while Firebird
is 100% free )
However as i said before my main database is SQL 2005 , if you can aford it
i would say go for SQL 2005 as it is in my opinion the dream of every VS.net
developer as a DB (Superior fast , easy in use , broad comunity with lots of
help and howtos availlable etc etc ) however it costs a few bucks :-(
michel
"Algonquin J. Calhoun" <Algon@xxxxxxxxxxx> schreef in bericht
news:9benc31hejbdjp36c3mhtpgoinpidsl306@xxxxxxxxxx
Never heard of Firebird. Will have to look into it.
Thanks,
Al
On Tue, 21 Aug 2007 07:07:05 +0200, "Michel Posseth [MCP]"
<MSDN@xxxxxxxxxxx> wrote:
Well ....
for the best performance , best integration with VS i would say take SQL
2005 and just pay the fee
however if it rally needs to be a free RDBMS i would recomend Firebird
http://www.firebirdsql.org/ in contradiction to MYSQL it has verry good
free support and a active comunity , it has ADO.Net providers ( for free )
there are very nice graphical administration modules out there . there is
also a embedded version ( although i wouildn`t recomend this with a 16 GB
DB ) it is also very fast etc etc etc
it has no restrictions what so ever , so it can scale to the linits of the
system
HTH
Michel
"Algonquin J. Calhoun" <Algon@xxxxxxxxxxx> schreef in bericht
news:tahkc3ljv2jlnb15otvbdv7dq17k2n7pfj@xxxxxxxxxx
I've developed an application that exceeds the Access 2GB limit. This
application was developed as a prototype and the users have found it
very
useful. Approximately 45,000 records are added to the database each
day.
Every 3 months I have to archive some of the older detail rows to allow
continued running of the application against the most current 90 day
data.
The users have decided to incorporate ALL of the data for their
analysis.
Initially it is going to be about 16GB.
I'm looking for a database that will house the 16GB and be able to
handle
the transaction volume. Limited multi-user capability - up to 5 users
doing
inquiry only. The most current 90 data will be used by the current
system
on a daily basis. The older data for research, used in a standalone
process. Since the application is written in VB.net 2005, the DB must
interface transparently, just as Access or SQL.
Cost will be one of the key factors in the decision. I've read about
these DB's with some of my comments.
SQL Express - can't handle 16+ GB
MS SQL Server - high cost
SQL Lite - don't know if it slips right in to VS development
environment.
If anyone has any recommendations of other DB's that fit the bill please
respond.
Al
.
- References:
- Time to migrate from Access DB to???? ---- Need recommendations
- From: Algonquin J . Calhoun
- Re: Time to migrate from Access DB to???? ---- Need recommendations
- From: Michel Posseth [MCP]
- Re: Time to migrate from Access DB to???? ---- Need recommendations
- From: Algonquin J . Calhoun
- Time to migrate from Access DB to???? ---- Need recommendations
- Prev by Date: Re: Web service and business logic
- Next by Date: Re: Solution definitions problem
- Previous by thread: Re: Time to migrate from Access DB to???? ---- Need recommendations
- Next by thread: Re: Time to migrate from Access DB to???? ---- Need recommendations
- Index(es):
Relevant Pages
|
