Windows installer (WiX based) including SQL express installation
$500-3000 USD
Paid on delivery
**Overview**
Reveal Media sells both cameras and software (called DEMS) to manage the video footage. As part of our next generation product we will be providing a slimmed down version of our current software to our client base. This software will be distributed either on the internal SD card of our camera or via download over the internet. This is only an overview of the items that will be required, there is a more detailed word document attached.
OS requirements - The installer must run on the following OSs - XP, Vista and Windows 7. The uninstall must be clean. Note we will test this with the Windows 7 logo program self certification tool.
**Bootstrap**
The requirements are a boot strap process to install the following items (if not present on the client PC). Ideally this will use the Burn tool provided by the WiX tool chain.
.Net 4.0 full profile - either download from the internet or install from distribution media.
Microsoft SQL server express - Depending on the version currently installed, will need to check if the user has a version suitable for use with Data-Tier application components, if not installed install from either the distribution media or the internet.
**Installer**
.MSI installer written using the WiX installer components for the following items:
Database contents - Currently it is planned to use Data tier application components to install the database. This requirement may be open to change based on the workers previous experiences.
Services - There are currently four services installed by the system. One service is a WCF service so potentially ports will need url reservations.
Client applications - There are two WPF based client applications that are installed both as native and click once installations.
Configuration of config files -The applications and services will need to have their configuration files customised to the current PC.
Network shares - When running in network mode there is a requirement to open network shares on the users PC to specified folders.
**Upgrades**
Support for both major where the package GUID changes and minor version number upgrades must be present as part of the setup bootstrap.
## Deliverables
**Installation notes**
Reveal Media has made some technology choices, apart from using WiX to generate the installation .MSI file the rest of the choices are recommendations and suitable alternatives can be suggested.
The main requirements are:
a) On a clean OS installation the user does not have to make any active choices other than installation directories. (unless an advanced install is selected)
b) During an upgrade the msi is run in reinstall mode with no action on the users behalf.
The name of the product being installed is DEMS.
**Bootstrapper**
There is a requirement for a bootstrapper setup executable which checks the level of .net and sql server installed and installs the necessary components.
Ideally [login to view URL] (from the WiX 3.6 tool chain) would be used for this. It is appreciated that this currently a beta product and it might not be appropriate, any other bootstrapper would be acceptable.
**SQL server installation**
The intention is that if the user has a copy of SQL server already installed on the machine that it is used instead of installing a new instance. If an instance of SQL server is already installed the service pack level should be checked and if necessary the user should be prompted to upgrade the instance to a later service pack (ideally by providing a url). Otherwise a new instance of SQL server is installed.
There is a table of SQL versions and service pack levels at <[login to view URL]> to make a data tier application install work. This implies that versions of SQL server from 2005 upwards can be supported assuming the correct service pack level has been installed.
Since the services will be running as LocalService this needs to be added as a suitably authorised user within SQL.
The SQL database will be a "Data-tier Application Component" (DAC) installation as this provides version upgrade facilities.
If the user is not running as a database administrator then they should either be prompted to provide suitable credentials for the installation.
**Database installation**
Currently the plan is to use a data-tier application installation to provide versioning during installation.
There will be a requirement to also update various database entries (such as data directories, host name etc) based on the users entries.
It is expected that normally the database will run in integrated authentication mode, however as part of the installation the option to use SQL authentication should be provided if SQL server has already been installed.
**Services Installation**
DEMS has four main services that need to be installed, one of these services hosts a WCF webservice this may mean that the necessary ports should be opened on the windows firewall during installation.
The services will need to have their configuration files altered to have the correct sql connection strings.
One service acts as a background application that watches for cameras being plugged into a pc (see the client application section for more details) this service also talks to the WCF service so will require additional configuration.
**Data directory selection**
DEMS uses a couple of directories for its data storage, under normal circumstances this should be placed in the c:\ProgramData directory. If the user selects workgroup mode (rather than standalone) the directories that are created should be made available as windows shares for all users, one share will need to be writable by all users, two additional shares should be made available as read only shares.
**Client application installation**
DEMS has two main applications that the user interacts with an administration application and a client application. In both cases they are fairly simple .net applications with a small selection of COM components that need to be registered. They should be installed both as a click once application which is potentially shared over the network, and installed as a fully installed application on the installation client PC.
The final installation option is an application used for automatic copying of data from cameras into DEMS, this application is split into two parts. The first is a service which watches for cameras being plugged into the host PC, grabs the video footage then automatically moves it into DEMS. There is a monitoring application that talks to the service and shows the current status of the cameras and videos.
Project ID: #3679611
About the project
Awarded to:
8 freelancers are bidding on average $1788 for this job
