Building DataBase & All DataBase Object with Sample Data

prasanta pradhan

16y3k

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

prasanta pradhan16y ago
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 Mallisetti16y ago
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.