We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

opso
Posts: 8
Joined: Thu Apr 19, 2012 10:06 am

Create and install MSSQL 2008 R2 Database on request

Hello,

I have a particular scenario, trying to make all possible tests following the guides but really I can't figure out how to acheive this.
The installer should be responsible of creating a MSSQL 2008 R2 Database on request (and run creation script) or connect to an existing empty database (and checking if the connection is ok) in order to run the mentioned creation script.
Since I am very new to Advanced Installer and installers in general I would really appreciate some simple help on how acheive this.

Thanks in advance for your precious help.

Regards, Giuseppe
mihai.petcu
Posts: 3860
Joined: Thu Aug 05, 2010 8:01 am

Re: Create and install MSSQL 2008 R2 Database on request

Hello Giuseppe,
The installer should be responsible of creating a MSSQL 2008 R2 Database on request (and run creation script)
For this you can simply follow our related Configuring Databases with SQL Scripts user guide article.
connect to an existing empty database (and checking if the connection is ok) in order to run the mentioned creation script
Here's our How to test SQL connection parameters? article to help you with this.

If you find anything confusing in the above articles, just let us know so we can clarify.

All the best,
Mihai
Mihai Petcu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
opso
Posts: 8
Joined: Thu Apr 19, 2012 10:06 am

Re: Create and install MSSQL 2008 R2 Database on request

Hello,

Thanks for your answer.
I noticed that in the article http://www.advancedinstaller.com/user-g ... ction.html is reported "This tutorial will not work with ODBC drivers added in the ODBC page."
I am not sure if this is a mistake (This tutorial will not work without) or if I really have not to configure ODBC in oder to use this.
Moreover I would like to ask how it is possible to update a DB with a patch.

Thanks, Giuseppe
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Create and install MSSQL 2008 R2 Database on request

Hi Giuseppe,
I noticed that in the article http://www.advancedinstaller.com/user-g ... ction.html is reported "This tutorial will not work with ODBC drivers added in the ODBC page."
I am not sure if this is a mistake (This tutorial will not work without) or if I really have not to configure ODBC in oder to use this.
No, there is no mistake. The related sentence is a valid affirmation. In order to test an SQL connection the ODBC driver must be already installed on the target machine. If you want to make sure that the target machine already has the ODBC driver installed, then you must add to your package a pre-install prerequisite package that install the appropriate driver.
Moreover I would like to ask how it is possible to update a DB with a patch.
Here is a thread that debates How to run a sql script during a patch installation.

If you have any questions let me know.

Regards,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”