Results 1 to 4 of 4

Thread: Which DB would be best?

  1. Mar 6th, 2006, 05:06 PM #1
    FrostByte01
    FrostByte01 is offline

    Thread Starter
    New Member
    Join Date
    Mar 2006
    Posts
    1

    Which DB would be best?

    I'm writing a little standalone app that will need a backend to store data. It will not hold a great amount, but I would like it to be fast and securable. I don't want anyone mucking around with the data model or viewing data. I would also like this to be really easy to deploy. If my mom can do it then anyone can type of easy install.

    So, using Vb.Net (may try 2005 express), what are the pros and cons of different backends?

    Access
    SQL Express 2005
    SQL Lite
    some XML type thing
    Other?

    Thanks for any input.
    Edward
    Reply With Quote Reply With Quote
  2. Mar 6th, 2006, 09:01 PM #2
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Which DB would be best?

    Welcome to VBForums

    I don't use VB.Net, but there is some info in this thread which may be useful for you.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  3. Mar 12th, 2006, 05:39 AM #3
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Which DB would be best?

    "Some XML type thing" wouldn't be a good choice for security, but would be easy to deploy.

    For ease of deployment, choose Access, because it doesn't require the setup of a server on the end-user's machine.
    Reply With Quote Reply With Quote
  4. Mar 12th, 2006, 07:52 AM #4
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Which DB would be best?

    This post: http://www.vbforums.com/showpost.php...28&postcount=5

    from a sticky at the top of the db section of this forum...

    describes how SQL Server 2005 Express can be used in a way very similar to ACCESS.

    you have to install SQL Server 2005 Express on the machine (but that should be invisible to the user)...

    but can "open/attach" to a database file without any of the DBA efforts required in the standard MS SQL product line.

    Visit the db section when you have questions like this...

    http://www.vbforums.com/forumdisplay.php?f=3

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width