Install SQL Server 2008 R2 Express in one installation file
-
Hi, I have an application in C# that use SQL Server 2008 R2 Express. When i install the package i need to choose option and to install: 1. Microsoft .Net Framework 3.5 SP1. 2. Windows Installer 4.5. 3. Windows PowerShell 1.0 I have an SQL Script that will build my DB at SQL 2008 R2 Express and will add the user configuration that i want. I want to make install package that will include the SQL 2008 R2 Express (including "Microsoft .Net Framework 3.5 SP1.", ,"Windows Installer 4.5" and "Windows PowerShell 1.0 "). Will run the script and install my application. I don't want to let the user to choose configuration for the DB in the installation process. How can i do that? Thanks, Shai.
-
Hi, I have an application in C# that use SQL Server 2008 R2 Express. When i install the package i need to choose option and to install: 1. Microsoft .Net Framework 3.5 SP1. 2. Windows Installer 4.5. 3. Windows PowerShell 1.0 I have an SQL Script that will build my DB at SQL 2008 R2 Express and will add the user configuration that i want. I want to make install package that will include the SQL 2008 R2 Express (including "Microsoft .Net Framework 3.5 SP1.", ,"Windows Installer 4.5" and "Windows PowerShell 1.0 "). Will run the script and install my application. I don't want to let the user to choose configuration for the DB in the installation process. How can i do that? Thanks, Shai.
-
Hi, I have an application in C# that use SQL Server 2008 R2 Express. When i install the package i need to choose option and to install: 1. Microsoft .Net Framework 3.5 SP1. 2. Windows Installer 4.5. 3. Windows PowerShell 1.0 I have an SQL Script that will build my DB at SQL 2008 R2 Express and will add the user configuration that i want. I want to make install package that will include the SQL 2008 R2 Express (including "Microsoft .Net Framework 3.5 SP1.", ,"Windows Installer 4.5" and "Windows PowerShell 1.0 "). Will run the script and install my application. I don't want to let the user to choose configuration for the DB in the installation process. How can i do that? Thanks, Shai.
X|
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
-
Hi, I have an application in C# that use SQL Server 2008 R2 Express. When i install the package i need to choose option and to install: 1. Microsoft .Net Framework 3.5 SP1. 2. Windows Installer 4.5. 3. Windows PowerShell 1.0 I have an SQL Script that will build my DB at SQL 2008 R2 Express and will add the user configuration that i want. I want to make install package that will include the SQL 2008 R2 Express (including "Microsoft .Net Framework 3.5 SP1.", ,"Windows Installer 4.5" and "Windows PowerShell 1.0 "). Will run the script and install my application. I don't want to let the user to choose configuration for the DB in the installation process. How can i do that? Thanks, Shai.
My preference, and I think there are others here who agree, is to not try to do that. Simply document the system requirements of the application and let the user install what's needed however they like. Think of it this way... what if your install installs today's current features, but a user wants to install it sometime in the future and doesn't want to install "old" versions of this stuff. Plus, the user may already have the stuff you require installed (or better). Why install SQL Server Express when the user already has the full package? Or maybe the user wants to have SQL Server on a server (where it belongs), not on his workstation? Your install should install your application and nothing else.
-
Hi, I have an application in C# that use SQL Server 2008 R2 Express. When i install the package i need to choose option and to install: 1. Microsoft .Net Framework 3.5 SP1. 2. Windows Installer 4.5. 3. Windows PowerShell 1.0 I have an SQL Script that will build my DB at SQL 2008 R2 Express and will add the user configuration that i want. I want to make install package that will include the SQL 2008 R2 Express (including "Microsoft .Net Framework 3.5 SP1.", ,"Windows Installer 4.5" and "Windows PowerShell 1.0 "). Will run the script and install my application. I don't want to let the user to choose configuration for the DB in the installation process. How can i do that? Thanks, Shai.
Indeed, don't force your customer to install sql express. I agree to PIEBALDconsult post. Maybe its the easiest way to create your installation, but its the wrong way. Your installation should get the required data (connection settings etc.), check the connection, then it should install the database. If the connection fails, cancel the setup.