Solved

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

Posted on 2014-02-20
11
174 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SLMGR Switches Are Not Working On KMS Host 3 70
Saveas need to save a copy 16 26
Advice on Xojo as a development tool over VB. 4 40
Close form "before" open 3 28
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

867 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now