SharpSetup can be used to install applications that require Microsoft SQL Server. This involves several distinct problems to solve:

  • Asking user if the SQL Server to use is a server available somewhere on the network or the local machine is to be used.
  • If the local system is to be used we need to detect whether SQL Server is already installed or not.
  • If it is not installed we need to download and install it.
  • If the SQL Server instance to be used is located on the network we may need to collect credentials needed to connect to this instance.
  • We need to identify the database to use or generate new one.
  • If the database already exists we may need to upgrade its schema instead of creating a new database.

As you can see creating an installer for an application using SQL Server is not trivial. However, thanks to features provided by SharpSetup this can be handled with ease and flexibility. In the next articles we will go through the steps necessary to implement the setup package that:

  • Has three additional wizard steps to handle SQL Server installation and configuration.
  • Handles both local SQL Server installation and using SQL Server available on the network.
  • Supports both creation of new databases and upgrades to existing databases.

This series will present new features available in SharpSetup 2.2. Stay tuned for subsequent articles.