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.

LVL 4
batchakamalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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..
0
imran_fastCommented:
my suggestion is same as ved17nov but
use isqlw command instead of xp_cmdshell
0
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.

0
imran_fastCommented:
Yes you can take these input from the user using small application
replace it in the batch file and then run the batch file.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.