Results 1 to 6 of 6

Thread: How to Install Sql

  1. Feb 20th, 2009, 09:31 PM #1
    freq
    freq is offline

    Thread Starter
    New Member
    Join Date
    Feb 2009
    Posts
    2

    How to Install Sql

    I need to install sql with my vb app.
    Can someone recommend a tutorial?
    Reply With Quote Reply With Quote
  2. Feb 20th, 2009, 09:58 PM #2
    snakeman
    snakeman is offline
    Hyperactive Member snakeman's Avatar
    Join Date
    Aug 2006
    Posts
    351

    Re: How to Install Sql

    here you can download The SQL Server 2005 Express Edition Or Sql Server 2008 Express Edition
    and watch A good video lessons on how to use the sql server in your App or Website
    here
    SQL Server Express Learn

    i hope this helps

    if i helped you please rate
    Last edited by snakeman; Feb 21st, 2009 at 01:34 AM.
    VB6 Control Tricks,VB Zone,
    Planet Source Code ,
    API Guide ,VB.NET Beginner Lessons,
    if anyone helps you just Rate
    Reply With Quote Reply With Quote
  3. Feb 21st, 2009, 12:15 AM #3
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: How to Install Sql

    Welcome to the forums!

    Here's another one.
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  4. Feb 21st, 2009, 11:35 AM #4
    freq
    freq is offline

    Thread Starter
    New Member
    Join Date
    Feb 2009
    Posts
    2

    Re: How to Install Sql

    Sorry, I wasn't specific enough. I need to deploy sql server express.
    I am creating a vb.net application to distribute.
    This application requires sql server. I would like to have the end user install, in addition to the application, sql server express and run a .sql script to install the db and tables.
    What is the best method to do this?

    Quote Originally Posted by snakeman
    here you can download The SQL Server 2005 Express Edition Or Sql Server 2008 Express Edition
    and watch A good video lessons on how to use the sql server in your App or Website
    here
    SQL Server Express Learn

    i hope this helps

    if i helped you please rate
    Reply With Quote Reply With Quote
  6. Feb 21st, 2009, 01:08 PM #5
    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: How to Install Sql

    From what I've seen the deployment options for VB.Net programs already include the option for SQL Server Express - you just need to tick a box while creating the package.

    As for running the script, I would recommend doing that when your program is first run (and save a value in your settings so you know it has been done).
    (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
  7. Feb 21st, 2009, 02:41 PM #6
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: How to Install Sql

    Or optionially create a backup of your empty database. Distribute that backup with the app. Include a method in your app to perform Backup and restore of database. Have the user perform a restore of the inital backup on first run of the application
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    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