Re: VistaDB Database


"Johnny Jörgensen" <jojo@xxxxxxxxx> wrote in message news:usIP4tZqHHA.4108@xxxxxxxxxxxxxxxxxxxxxxx
Hi all

I just saw an ad in the latest ComponentSource newsletter for a database engine called VistaDB 3.0.

http://www.vistadb.net/default.asp

It looks very interesting as a database engine for smaller applications where you would normally use access. Plus it can be embedded into the exe.

I've just started doing a small database application, and my concern has been this: Should I use access or SQL server?

There is MS SQL Server 2005 Express Edition which is free to download and distribute.


Access is simpler and actually quite sufficient for my needs (very small database - only a few tables), but it seems old fahioned to me. But at the same time, I've been reluctant to choose SQL Server because it complicates the administration and deployment. Access is simply a file you copy, but with SQL server you have to install the engine and check in the installation if it exists, attach the database... Not extremely complicated but still a little overkill for my application.

With ADO.NET and the MS DB provider like SQL Client, you can deploy a SQL Express MDF file, just like you can with an MDB file. All you have to do is provide the connection string. I have found SQL Server 2005 Express pretty easy to use in an ASP.NET solution and easy to connect with .NET Server Explorer where you just drag the database to App_Data in the Solution Explorer. I would assume it would be the same for a .NET NT Service, Console Application and Windows desktop solution as well.

SQL Server Express doesn't seem like you have to deploy the Admin part of the solution to a Client machine, but I have not gotten to that part, yet. Yes, you would have to Attach the file using SQL Exress 2005 Manager to administer the database with its Manager solution, just like you would with SQL Server Manger if it's the Standard Edition of SQL Server 2005 or previous versions were being used.



So I though of testing VistaDB, but I just wonder if anybody knows of it and has experiences using it they would like to share???


This VistaDB seems interesting. It's something to keep in mind. Maybe, there will be some kind of (free) Express Edition.

.

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Connectivity
    ... Never was Jet mentioned anywhere at anytime. ... >> Microsoft Access Database Solutions, with not a single mention of Jet. ... front end, and the underlying database engine, JET. ... like SQL Server, Sybase, MySQL, etc. ...
    (comp.lang.python)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)