Question Desktop Database

[Rossmc]

Hi All

I develop a single-user desktop application. (Currently VB6/Access). We are busy migrating to VB.NET.

My question is, what are the best options for the database?

I was wanting to move away from Access due to database size issues (it's ALOT of data).
Also, although it is primarily a single-user/single database application, it is likely that I would want to support multiple users on a single database going forward.

Many thanks.

 

[MattP]

SQL EE may be something to look into.

Since you're looking to move from VB6 to VB.NET I'd recommend this series for working with data: Visual Basic How Do I Video Series. In particular I'd look at #10 Work with Local Data.

 

[Hack]

What kind of a budget do you have to work with?

 

[jmcilhinney]

SQL Server Express would probably be your best bet for the time being. It's free, it supports databases up to 4GB, it has tight integration with VS and it uses the same database format as SQL Server so an upgrade later is seamless.