Post reply

to create exe for sql

  • July 8, 2008 at 8:07 am

    #187929

    H! all,

    I m totally NewB in SQL (which can be understood from my question also.......)

    current i m working on VB in which data is accessd from SQL database.....In DB, i have created some tables manualy.....Now, suppose i want to run my application on other machine, i need same tables on that machine.....so how to create tables there with any EXE...

    Hope, some exepert have got my problem and will answer ealiest

    ABHI-NewB

  • July 8, 2008 at 9:12 am

    #839552

    Is your SQL database on a remote server? Or is SQL on the local machine so you need to create all the database tables the first time the program is run?

    ---
    Dlongnecker

  • July 8, 2008 at 10:13 am

    #839614

    First Use SQL Server Express Editions.

    Second: Either you can create a SQL Script and RUn it when the applicaiton is EXECUTED or let the SETUP Program (INSTALLER) that comes with visual Studio or 3rd PArty Programs..

    Maninder
    www.dbanation.com

  • July 8, 2008 at 11:29 pm

    #839869

    hi mani,

    Thanx a lot.......Can u tell me more about SETUP Program (INSTALLER) that comes with visual Studio....and how to use it...I have visual studio 6.0.

    Abhi..

  • July 10, 2008 at 8:00 am

    #840835

    hi all

    i have come to conclusion that simple way of creating exe for sql is that

    1. create sql script having stored proc

    2. open script (txt) file from ur frontend VB, asp etc

    3. execute stored proc

    now use this programm whenever u want to create DB on other machines..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply