+ Reply to Thread
Results 1 to 4 of 4

Thread: Desktop Database

  1. #1
    Rossmc is offline VB.NET Forum Newbie Rossmc is on a distinguished programming path ahead
    .NET Framework
    .NET 2.0 (VS 2005)
    Join Date
    Mar 2009
    Posts
    12
    Reputation
    20

    Default Desktop Database

    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.

  2. #2
    MattP is offline VB.NET Forum All-Mighty MattP has a reputation beyond repute MattP has a reputation beyond repute MattP has a reputation beyond repute MattP has a reputation beyond repute MattP has a reputation beyond repute MattP has a reputation beyond repute MattP has a reputation beyond repute MattP has a reputation beyond repute MattP has a reputation beyond repute MattP has a reputation beyond repute MattP has a reputation beyond repute
    .NET Framework
    .NET 4.0
    Join Date
    Feb 2008
    Location
    USA
    Posts
    1,039
    Reputation
    534

    Default

    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.

  3. #3
    Hack's Avatar
    Hack is offline VB.NET Forum Master Hack probably authored a book by now Hack probably authored a book by now
    .NET Framework
    .NET 3.0 (VS 2005/2008)
    Join Date
    Apr 2009
    Location
    Sterling Heights, MI
    Age
    60
    Posts
    336
    Reputation
    57

    Default

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

  4. #4
    jmcilhinney's Avatar
    jmcilhinney is offline VB.NET Forum Moderator jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute jmcilhinney has a reputation beyond repute
    .NET Framework
    .NET 3.5 (VS 2008)
    Join Date
    Aug 2004
    Location
    Sydney, Australia
    Age
    41
    Posts
    6,907
    Reputation
    670

    Default

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts