Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-08-26
1
Medium Priority
?
273 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 2000 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

661 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