How to Create Database in InstallShield - Application Deployment

Posted on 2006-04-18
Last Modified: 2012-08-13
I have developen an application in PowerBuilder and I prepared the deployment using InstallShield Professional.
Now everything goes fine, but I want to create some stored procedures in Master database and also I have to create a database with some tables and stored procedures.

How can I do this in InstallShiled?

I don;t find a space for InstallShiled Questions.. thats why I posted here.

Question by:batchakamal
    LVL 142

    Accepted Solution

    LVL 11

    Assisted Solution

    by:Ved Prakash Agrawal
    There are one way to acheive this thing.

    use can create bat script which use can run throught installshield.
    in batch script you can use xp_cmdshell to login into server and then execute the sql script
    you can also use sqlcmd for the same thing..
    LVL 28

    Assisted Solution

    my suggestion is same as ved17nov but
    use isqlw command instead of xp_cmdshell
    LVL 4

    Author Comment

    Ok, but I want the user has to enter the SQL Login Id and Password.

    May be ur solution is ok if I know the server name, database name, log id and password.

    LVL 28

    Expert Comment

    Yes you can take these input from the user using small application
    replace it in the batch file and then run the batch file.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now