Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How can I get a SQL Server Database to install with my Windows App?

Posted on 2014-08-07
8
Medium Priority
?
112 Views
Last Modified: 2014-08-14
I have never created an install package where I included a SQL Server Database. Can someone point in the right direction as to how to do this?

Thanks,
0
Comment
Question by:BlakeMcKenna
  • 4
  • 4
8 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 40248374
If its the DB and not SQL Server itself then you have multiple options

1) Use scripts to create all your DB artefacts including metadata.
2) Create a backup of your DB on the dev environment and then restore this backup on your destination server.
0
 

Author Comment

by:BlakeMcKenna
ID: 40248602
Ok,

Perhaps I should have clarified myself. This is a stand-alone Windows application. It's an application that can be installed on someone's home computer. If what you say still applies, then I'm still not quite sure how to go about doing what your suggesting.
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 40248705
Would home computers have SQL server installed?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:BlakeMcKenna
ID: 40248789
Not necessarily....
0
 
LVL 83

Assisted Solution

by:CodeCruiser
CodeCruiser earned 2000 total points
ID: 40249088
So you need to do SQL Server installation first?
0
 

Author Comment

by:BlakeMcKenna
ID: 40249099
So I'm guessing the only way to have a self-contained database is to use MS Access and include that in the Setup Package? If so, how is that done?
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 2000 total points
ID: 40250525
With Access, you can just include the DB file in your folder and it should work as long as the Jet (for 2003 and older) or ACE (for 2007 onwards) is installed.
0
 

Author Closing Comment

by:BlakeMcKenna
ID: 40261310
Thanks CodeCruiser...
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
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…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month15 days, 12 hours left to enroll

580 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