Windows Develop Bookmark and Share   
 index > ClickOnce and Setup & Deployment Projects > Database Deployment using Setup and Deployment Project
 

Database Deployment using Setup and Deployment Project

Hi All,

My project is with Silverlight as the Client, WCF as the Services and SQL Server as the DB.

Am now creating a Setup for installing all the above components during my Project install.

Database: i am adding custom actions for deploying my DB- sql server. i also added the Views from the Default views list provided in the Setup Projects. am able to enter the DB name, uName, Pwd with the text boxes.

Question:
Is there an option in the Setup Projects where in we can add Customs BUTTONS to validate the TEST connections when we deploy a DB?

Isaw lot of links where it all says the Gets installed with the Default Views , when the NEXT button is clicked.

Any possibilities of including NEW SCREENS - CUSTOM VIEWS in the Setup & Deployment projects?

Please let know

Thanks
Senthil

http://dotnetcrunch.blogspot.com


MSenthilVel  Tuesday, July 28, 2009 9:21 AM
VS Setup Projects that build MSI files have a set of built-in dialogs that you can add, but in general you're correct, the installation sequence goes through the dialogs you add, Next->Next and so on.

There's nothing wrong with Setup Projects as a tool for building a basic install, but they're not fully-featured tools like many of the other tools that can be used to generate an MSI-based setup.

http://www.installsite.org/pages/en/msi/authoring.htm
Phil Wilson
PhilWilson  Tuesday, July 28, 2009 7:06 PM
hi Phil,

is it possible for installling both silverlight and WCF services using the same Setup Package?

pls let know
Thanks
senthil
http://dotnetcrunch.blogspot.com
MSenthilVel  Tuesday, July 28, 2009 8:17 PM

Hi MSenthilVel,

From my experience, it is possible. The main issue of your project is to show an interface to let the user input database information and update them to the configuration file of the installed program. We can create a new Form to cope with these things and show that form in the custom action handler. You can get more information about custom action from:
http://www.simple-talk.com/dotnet/visual-studio/visual-studio-setup---projects-and-custom-actions/.

Let me know if this helps.
Aland Li


Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.
Aland Li  Monday, August 03, 2009 3:15 AM
Hi Li,

Thanks for the reply i shall check the link ...

am right now facing issues in creating 2 virtual dir's in the same IIS through a single installer pckage...

basically i need to create one virtual dir for my silverlight client and one for the WCF services.....

pls Let me know on to go about installing 2 vir dirs..

Thanks
Senthil

http://dotnetcrunch.blogspot.com
MSenthilVel  Monday, August 03, 2009 3:54 AM

Hi MSenthilVel,

These are some links show how to manage virtual directory in code:
C#: http://www.c-sharpcorner.com/UploadFile/DipalChoksi/CreateVirtualDirs12052005234144PM/CreateVirtualDirs.aspx.
scripts: http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1805162e-6ac5-4a98-9a08-919c4c10827d.mspx?mfr=true.

You can follow the links above and write code in the custom action to add directories.

Let me know if this helps.
Aland Li


Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.
Aland Li  Tuesday, August 04, 2009 11:55 AM

Hi ALan,

Thanks for the links:

actually is there any other ways of calling an MSi inside another setup project ?

why am asking is --- my silverlight MSI works fine and also my WCF MSi works fine...so when i used one inside another thru a custom action i am getting an errr...any other ways to include one msi in another Setup project ?

Pls let know

Thanks
Senthil
http://dotnetcrunch.blogspot.com

MSenthilVel  Wednesday, August 05, 2009 5:51 PM

You can use google to search for other answers

Custom Search

More Threads

• How to include files in final published app?
• Windows Installer projects always build in VS2008
• CD for install and Click-once for upgrades
• Query on handling updates/patches using clickonce deployment
• VB 2005 SignTool Publish Error
• ClickOnce installation path problem
• Chain SQLExpress2008 Install
• Warning while adding the primary output to the setup project
• localization on clickOnce
• Install multiple instances of an msi on one box?