J
JDS
I have an application that needs to be deployed and include the setup
of a SQL Server 2005 Express database. There are several tasks that
need to be performed and I want to wrap them up in to a single
deployment package using Windows Installer. However, I am new to
deployment and I am struggling to find the answers on the basic msdn
help sections, e.g.
http://msdn2.microsoft.com/en-us/library/ybshs20f(VS.80).aspx
http://msdn2.microsoft.com/en-us/library/206sadcd(VS.71).aspx
In addition to installing the application itself and the .Net
framework I also need to perform the following tasks:
- check if SQL Server 2005 Express is already installed
- if not, perform a custom installation to include connectivity
components, etc
- check the existance of the database, if it does not exist then
install it
- run several sql scripts to attach the database, create logins,
users, subscriptions, etc
- create a Windows user
I have found how to perform a custom installation of SQL Server from
the command line:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
and how to add a windows user from the command line:
http://www.microsoft.com/resources/.../xp/all/proddocs/en-us/net_user.mspx?mfr=true
but I do not know the best way of combining these, the coying of the
database and the sql scripts into a deployment project.
Any help or pointers in the right direction would be really
appreciated.
of a SQL Server 2005 Express database. There are several tasks that
need to be performed and I want to wrap them up in to a single
deployment package using Windows Installer. However, I am new to
deployment and I am struggling to find the answers on the basic msdn
help sections, e.g.
http://msdn2.microsoft.com/en-us/library/ybshs20f(VS.80).aspx
http://msdn2.microsoft.com/en-us/library/206sadcd(VS.71).aspx
In addition to installing the application itself and the .Net
framework I also need to perform the following tasks:
- check if SQL Server 2005 Express is already installed
- if not, perform a custom installation to include connectivity
components, etc
- check the existance of the database, if it does not exist then
install it
- run several sql scripts to attach the database, create logins,
users, subscriptions, etc
- create a Windows user
I have found how to perform a custom installation of SQL Server from
the command line:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
and how to add a windows user from the command line:
http://www.microsoft.com/resources/.../xp/all/proddocs/en-us/net_user.mspx?mfr=true
but I do not know the best way of combining these, the coying of the
database and the sql scripts into a deployment project.
Any help or pointers in the right direction would be really
appreciated.