how to deploy a db into our application

Posted by Madhuri123 under Sql Server on 3/18/2011 | Points: 10 | Views : 3133 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

Latest Posts