Building DataBase & All DataBase Object with Sample Data

Question

Hi...

Recent we are deploy(Setup and Deploy) our Product which is develop in ASp.Net(C#) using SqlServer Here We Face one Problem i.e.

When we install the porduct there is no issue if we manually run the sqlScript file in sql server(manully we create the DataBase and All DataBase Object i.e. Table,StoreProcedure,Function,Views....& We are enter the Sample Data) But We know that is not the Right Approch.

Any one Can tell me the procedure "How to Building DataBase & All DataBase Object with Sample Data when we click the Install and set up file"

In Setup and Deploy wized it ask for any Dependence file for the application i have attach the Dependence file(.sql) but i am not getting any OutPut .

Is there any Command prompt Utility(SqlServer/VS Commandprompt) ?????

If any One know the Procedure plese Help Me or any sutilble URL link Or Advice....

Thank's

Prasanta Kumar Pradhan

http://globaltouch.in

prasanta pradhan · Answer

hi.. Thank's For Your Reply. I am not asking manually backup/ restore database in sql server. I think u r not fully go through my post. I am asking Building DataBase & All DataBase Object with Sample Data when we click the Install and set up file which is created in asp.net Deployment.i.e. on click Setup project application in install & database with all obect & sample data. Hope if u have idea u will share me. Thank's Prasanta Kumar Pradhan

Koteswararao Mallisetti · Answer

first you take the backup the database file it gie .mdf and .ldf you carry that files you must restore (restore database option in sqlserver->database ->rightclick-> ->...)that file in actual sqlserver location of the application the i think it will work.