• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

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

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
BlakeMcKenna
Asked:
BlakeMcKenna
  • 5
  • 5
1 Solution
 
Jacques Bourgeois (James Burger)PresidentCommented:
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
 
CodeCruiserCommented:
>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
 
BlakeMcKennaAuthor Commented:
CodeCruiser,

You are correct. I'm taking this app and installing in on a standalone desktop machine.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
CodeCruiserCommented:
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
 
BlakeMcKennaAuthor Commented:
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
 
CodeCruiserCommented:
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
 
BlakeMcKennaAuthor Commented:
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
 
CodeCruiserCommented:
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
 
BlakeMcKennaAuthor Commented:
Ok,

Let's say I go the with SQL Server CE, how do I get that in my Setup Project?
0
 
CodeCruiserCommented:
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
 
BlakeMcKennaAuthor Commented:
Thanks CodeCruiser...those were good examples!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now