Solved

Installing SQL Server support files in a Visual Studio 2008 Installer project

Posted on 2010-08-26
1
270 Views
Last Modified: 2013-11-27
I have creating a .NET 3.5 application using Visual Stuido 2008.  I have made use of some features contained in the Microsoft.sqlserver.Smo Dll and want to ensure that my application will run on the target machine which may or may not have SQL Server 2008 installed (most likely it will not as these are client PCs).

I have created a Visual Studio 2008 Installation project which correctly lists the dependancies and installs the product correctly however I am not sure if just because the dependancy is listed in the installation project that the relelvant SQL server files are being installed.

Can anyone tell me if this is the case or if not how I can ensure that correct version of these files can be included in my setup project and installed along with the application.

In a similar way, my application uses .NET 3.5 and this is listed as a dependancy - will the installer install .NET 3.5 if required.

Sorry about the basis questions but I have always used InstallShield previously but no longer have a license so am trying to see if the in-built installer is sufficient for my requirements.
0
Comment
Question by:ChrisMDrew
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 33544531
>>which may or may not have SQL Server 2008 installed (most likely it will not as these are client PCs).<<
My understanding is that you will require a SQL Server license installed on any workstation that uses SMO.

You can download the distributable package here:
Microsoft SQL Server 2008 Feature Pack, August 2008
http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question