how to deploy a db into our application

Posted by Madhuri123 under Sql Server on 3/18/2011 | Points: 10 | Views : 2076 | Status : [Member] | Replies : 3
Hi SIr,
This is Madhuri. I implemented a stand alone application in c# and i create a database also to this project.
how to deploy a database into our application.




Responses

Posted by: SheoNarayan on: 3/18/2011 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
You can script the database by right clicking the database in the SQL Server Management studio, select Script Database As > Create To > New Query Editor Window (other options are also there) and save that as .sql file. Open the Management studio on the server and execute this .sql file. This should create a database on the server.

Now create necessary username by going to Security folder and assign database for this user and specify the database connection string accordingly in your application.

Hope this helps

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Madhuri123, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Gsolvers on: 3/18/2011 [Member] Starter | Points: 25

Up
0
Down
Can i get the type of DB you are using?

Best Regards,

VG
www.TeacherJi.com

Madhuri123, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/25/2012 [Member] Starter | Points: 25

Up
0
Down
1) RIGHT CLICK U R DATABASE GENETATE SCRIPT OR RIGHT CLICK U R DATABASE --> TASK ---> BACKUP DATABASE

REGARDS


sriram

Madhuri123, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response