954,515 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

HOW TO DEPLOY vb.net application with database(sqlserver)

hi friends can any one help me in deploying vb.net project with database(SQL SERVER)

mvnk12
Newbie Poster
4 posts since Jul 2008
Reputation Points: 10
Solved Threads: 0
 

what the mean of "deploying"?
make it more clear...

Jx_Man
Nearly a Senior Poster
3,329 posts since Nov 2007
Reputation Points: 1,372
Solved Threads: 444
 

Do you mean that you want to Package and Deploy the Windows App to the Client Machine with SQL Server Database?

regcure
Newbie Poster
7 posts since Jun 2008
Reputation Points: 10
Solved Threads: 0
 

You will have to use the Setup and Deploy Project type in .Net, add the project files, dlls, etc and build the project as a cab file, etc. You can then choose to Deploy the files by creating a Setup project. For the SQL DB-you will need to generate scripts for the DB and tables and run the scripts manually on the client or if you can do it--Detatch the DB (mdf and ldf) from your SQL Server-and attach the mdf and ldf files to the client server.

sierrainfo
Junior Poster
144 posts since May 2008
Reputation Points: 10
Solved Threads: 9
 

wher the application can be run on the client machine with the .exe and dll's

mvnk12
Newbie Poster
4 posts since Jul 2008
Reputation Points: 10
Solved Threads: 0
 

yes i want to run it on client machine

mvnk12
Newbie Poster
4 posts since Jul 2008
Reputation Points: 10
Solved Threads: 0
 

This article gives you a step by step process for Setup and Deployment.

http://aspalliance.com/622_StepbyStep_Process_of_Creating_a_Setup_and_Deployment_Project.all

sierrainfo
Junior Poster
144 posts since May 2008
Reputation Points: 10
Solved Threads: 9
 

Thanks SierraInfo..

That was a brillient article..

reniies
Newbie Poster
11 posts since Jul 2008
Reputation Points: 10
Solved Threads: 1
 

Thank you. Always help others whenever you can. Knowledge is for sharing.

Please do mark this thread as solved.

sierrainfo
Junior Poster
144 posts since May 2008
Reputation Points: 10
Solved Threads: 9
 

hi guys..
actually i got same problem as mvnk12. i don't know how to deploy vb.net web application for my project. Actually i was take over old project from my senior. then i need made some changes in that web application. can i just rebuild the setup?and besides, can i just paste the older bin folder with the new one to make it run?hope somebody can teach me..

tq,
ct.

bungek84
Newbie Poster
17 posts since Dec 2007
Reputation Points: 8
Solved Threads: 0
 

If you are using .Net 1.1-Build the Application and copy the dll in the bin folder to the bin folder in your Web Host. If you are using .Net 2.0- a dll is not created (you can if required)-the pages are compiled dynamically-so you just need to copy the changed pages to the Web Hosting Server.

sierrainfo
Junior Poster
144 posts since May 2008
Reputation Points: 10
Solved Threads: 9
 
If you are using .Net 1.1-Build the Application and copy the dll in the bin folder to the bin folder in your Web Host. If you are using .Net 2.0- a dll is not created (you can if required)-the pages are compiled dynamically-so you just need to copy the changed pages to the Web Hosting Server.

I'm using .NET 1.1. After i paste it at my web host, so i can access the system as usually rite??
thank sierrainfo for ur info..really appreciate it.

bungek84
Newbie Poster
17 posts since Dec 2007
Reputation Points: 8
Solved Threads: 0
 

Correct. But to be safer-you should also copy the changed content pages and the code files for the pages, so that the changes done on your local server also reflect in the content on the server. This is to ensure that future developers can download updated pages-work on them-create the dll-and repeat the process.

sierrainfo
Junior Poster
144 posts since May 2008
Reputation Points: 10
Solved Threads: 9
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You