how to deploy application with sql server 2008

Question

0.00/5 (No votes)

See more:

I deployed an setup and install tat in another machine throwing an error.. so anyone can guide me step by step method to deploy an application with database...
(I had googled I can't find best answer for this so your guidance ll help me )

Posted 4-Dec-12 20:07pm

selva_1990

Add a Solution

Comments

Expert Coming 5-Dec-12 2:09am

What is the error?

selva_1990 5-Dec-12 2:18am

can't find database source this is error and onething I didn't deploy correctly so I need steps to include database while deploying

choudhary.sumit 5-Dec-12 2:27am

are you attaching your database with this setup?? and wrote script to restore on another machine??

selva_1990 5-Dec-12 2:37am

i do not know tat procedure, without database i know to depoly an c# application... can u able to guide me step by step.... i finished my project i need to submit.. its urgent

choudhary.sumit 5-Dec-12 2:49am

ok..i can. first make a backup file of your database. put it in your application directory in which application will be installed. continued..

selva_1990 5-Dec-12 3:00am

i did and output file name is "stand.bak" now in which folder i need paste tat backup

choudhary.sumit 5-Dec-12 3:28am

ok tell me how are you deploying your project.are u using a setup project or anything else.? i will leave a video tutorial for u.. wait for the eve.

selva_1990 5-Dec-12 3:36am

sounds good thank u.., yes its SETUP PROJECT... i have created database in SQL SERVER 2008..., i need to include tat to my setup... if i install tat setup in other machine, it should work tat's all...,
(if possible explain with one small addition application with database)

selva_1990 5-Dec-12 4:49am

i m waiting for ur tutorial

choudhary.sumit 5-Dec-12 5:45am

hi. you will need a database backup script when you will run your app first time so we create a code for this.. you must have a look on this...
http://www.codeproject.com/Articles/26390/SQL-Server-2005-Database-Backup-and-Restore-using
it is just an code we need some more. we will have to check the same database does'nt exist already on the other computer. if not then we will run the script and if yes then we skip the restoration and just redirected to our main windows form.. so u already created your backup.. temporarily put it anywhere and use this code.just do it and i will b back with u after some time.

choudhary.sumit 5-Dec-12 5:56am

ok.. right click on your setup project in solution explorer. goto "Add" >> "file".. and add your stand.bak file here.
and make a restoration from here with the code shown in the above comment's link... keep your backup somewhere also. becoz you have to delete the databse from server if u r just testing your code with restore.

selva_1990 5-Dec-12 9:18am

video ll help me lot waiting for ur response...
i hope u'll leave video tutorial

selva_1990 6-Dec-12 4:28am

i m waiting for ur reply

selva_1990 5-Dec-12 7:22am

i m bit confused can u leave video tutorial... it ll help lot of them plz

selva_1990 5-Dec-12 7:37am

video ll help me lot waiting for ur response...
i hope u'll leave video tutorial

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Krunal Rohit · Answer 1 · 2012-12-04T21:12:00

Solution 1

Hi,
See http://social.msdn.microsoft.com/forums/en-US/sqlexpress/thread/d3449ca5-4fd7-4c0b-8db6-ea79a954b296/[^]

Posted 4-Dec-12 21:12pm

Krunal Rohit

Comments

selva_1990 5-Dec-12 3:19am

its difficult to understand

[no name] 5-Dec-12 3:22am

But you'll have to go through it :)

selva_1990 5-Dec-12 3:27am

do u have any other format like tutorial or something

[no name] 5-Dec-12 3:29am

Nope.. but try it out :)

selva_1990 5-Dec-12 3:42am

k k fine

[no name] 5-Dec-12 3:44am

Accept/Rate solution, if you're satisfied with that..