Creating an installer package to install Application and MySQL automatically

hi,
    I have written a VB application and it uses MySQL, I want to configure an installer which will automatically rollout MySQL, apply the required SQL code to create the database, tables and structure, then install my App - leaving the customer with a fully working solution.

Does anybody have any ideas?

Thanks
damianb123Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Deepu SreedharConnect With a Mentor BI Software EngineerCommented:
0
 
almanderCommented:
I would add something to your application to do this. As opposed to making it part of the installation process. Something like a Create new database procedure in your application that is executed when the application is first run.

To create the database I would execute a script that has all of your necessary commands in it.

If you want to install mysql automatically, more information about your environment is needed. But you should look for a MySQL bootstrap installation that matches your environment.
0
 
gplanaCommented:
You should create an installer using InstallShield or something similar. You should also include the MySQL installer if you want to install MySQL at the target machine.

For getting SQL sentences to create the databases, just use phpMyAdmin which has an option to export database to SQL commands. Save this to a text file, and execute this on the target MySQL to create the database with its contents.

Hope it helps.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
almanderCommented:
No need for installshield unless you already have it, you could still use the installer in Visual studio. Depends on the version of visual studio you are using?
0
 
gplanaCommented:
I want just to note that some Visual Studio versions include some versions of InstallShield, like InstallShield Express.
0
 
damianb123Author Commented:
Hi, I'm using visual studio 2008 professional
0
 
Deepu SreedharBI Software EngineerCommented:
In VS 2008, you can create the installer and add MySQL as a pre-requisite. Then before the application installs, it will install the MySQL from the specified path. Either from the installation disc or by downloading from the manufacturer.
0
 
damianb123Author Commented:
Thanks deepusreedhar,
    Could you provide more information on where I can do this  and how within VS 2008?

Thanks
0
 
Deepu SreedharBI Software EngineerCommented:
Hope you know how to create a deployment project for your application in your solution.
then you can right click on the deployment project to get into the property page where you can find the prerequisites button. there you have the option to choose prerequisites and tick box for create installer package for them and options for downloading from website while installing or to install from CD or so. See the attached file,
property-page.JPG
prerequisites.JPG
0
 
damianb123Author Commented:
But when I check it doesn't give the option for MySQL, only SQL Server from Microsoft.  How can I add my own items into the pre-requisites?

Thanks
0
 
damianb123Author Commented:
Perfect, this worked great!

Thanks
0
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.

All Courses

From novice to tech pro — start learning today.