Solved

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

Posted on 2014-02-20
11
173 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

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…
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 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

18 Experts available now in Live!

Get 1:1 Help Now