Solved

Creating an instance of a SQL Server DB and adding it to a Setup Project

Posted on 2014-02-20
11
175 Views
Last Modified: 2014-02-26
I have never been able to do this and have always defaulted to using a MS Access DB. How do I create an instance of a SQL Server DB, add it to my Setup Project and install the application on a remote PC (which doesn't have SQL Server installed on it)?
0
Comment
Question by:BlakeMcKenna
  • 5
  • 5
11 Comments
 
LVL 40
ID: 39875799
The same way that you add install Windows with your application... you make it a prerequisite, presenting your user with a link to the download page at Microsoft.

If you deploy in house however, you might want to consider ClickOnce deployment, since it enables you to include the installation of various components, including SQL Server Express. (http://msdn.microsoft.com/en-us/library/142dbbz4(v=vs.90).aspx)
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 39876931
>which doesn't have SQL Server installed on it
>I create an instance of a SQL Server DB

It appears that you want to use your SQL Server DB without installing SQL Server. Is this assumption correct? If yes then look into SQL Server CE.
0
 

Author Comment

by:BlakeMcKenna
ID: 39877161
CodeCruiser,

You are correct. I'm taking this app and installing in on a standalone desktop machine.
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 83

Expert Comment

by:CodeCruiser
ID: 39885336
Have you tried SQL CE then? If you don't want to install SQL Server on the target computer then Access is a good choice.
0
 

Author Comment

by:BlakeMcKenna
ID: 39885561
But I've heard that you don't need to install a full blown version of SQL Server on a machine in this situation.
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 39885906
Yeah you can use SQL CE which does not require installing but it is quite limiting. Is your software only used on a single computer or many computers on a network?
0
 

Author Comment

by:BlakeMcKenna
ID: 39886034
Currently it is installed on 4 stand-alone PC's at work. We have SQL Server installed on a Database Server. What we are trying to do is perform an install in the field on stand-alone PC's that don't have SQL Server installed on them. Once installed on these PC's, the application will use the database installed on the machine and not our Database Server at work.
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 39886156
Then you have two options

1) Use a standalone database such as Access or SQL Server CE but this would require maintaining two databases.
2) Install SQL Server Express (FREE) as part of application setup.
0
 

Author Comment

by:BlakeMcKenna
ID: 39886184
Ok,

Let's say I go the with SQL Server CE, how do I get that in my Setup Project?
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 39888354
Easiest option would be to deploy the DLL files for SQL CE as part of your software (within the same folder).

Here are couple of resources

http://msdn.microsoft.com/en-us/library/aa983326(v=vs.90).aspx

http://robindotnet.wordpress.com/2010/02/28/how-to-deploy-the-sqlserver-compact-edition-software-locally/
0
 

Author Closing Comment

by:BlakeMcKenna
ID: 39888709
Thanks CodeCruiser...those were good examples!
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

777 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