• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

How to Create Database in InstallShield - Application Deployment

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.

3 Solutions
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
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..
my suggestion is same as ved17nov but
use isqlw command instead of xp_cmdshell
batchakamalAuthor Commented:
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.

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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now