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

x
?
Solved

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

Posted on 2014-02-20
11
Medium Priority
?
180 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
[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
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

722 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