SQL Server Install

[abhi2434]

I am building an installer for my project. I have few constraint on my project. Actually I was using my custom installer built myself before and many of the clients are already using it. What I was doing is give below :

1. Installer installs SQL Server 2005 and create database instance with my custom name.
2. Installer then creates the database, runs a sequence of scripts one by one and updates the database to the latest version.
3. Installer launches the VS MSI and installs it.

Now as I need to change the installer to SQL Server 2008 but I need to check whether there is already an instance already present using SQL Server 2005. If it is there, we need to use it, otherwise it will install SQL Server 2008. Is it possible using advanced installer ?

Do I need to purchase the product to do this ?

[Daniel]

Hello and welcome to Advanced Installer forums,

Thank you for your interest in Advanced Installer.

In order to achieve what you want you can add our "SQL Server 2008 Express" predefined prerequisite to your main project. Then, if you want to install it only if "SQL Server 2005" isn't already installed select the "SQL Server 2008 Express" prerequisite package and in the "Install Conditions" tab add the following launch condition (to the existing ones):

• Criteria: Registry value containing a version
  Registry Value: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\CurrentVersion\CurrentVersion
  Minimum Required Versions: 9.0

Also, if you want to use our "Prerequisites" feature then you need at least a Professional license of Advanced Installer.

If you need to run SQL Scripts during installation, then you should use our "SQL Scripts" feature. Please keep in mind that this feature is available only in an Enterprise or above license.

Here are a list of articles you can follow:
- Configuring Databases with SQL Scripts tutorial
- Using SQL Scripts
- ODBC/SQL how to's

If you have any questions let us know.

All the best,
Daniel