how to attach database created in sql server management studio to the currnt project

[praveenb000]

Hi frnds,

i created a database in sqlserver management studio, and i know how to connect that database to the current project.

but problem is when i change to another system(pc), i need to run whole script in that system's sqlserver management studio, again to create the same database there. and again connect to it.

(i know this task how to do.)

but i want my database should be within my solution explorer so that "if i shift to any another system(pc) that database should be carried with my project solution"

i know that this(the above task) can be done using by adding SQLdatabase (.mdf & .ldf files) to the solution explorer.

but my problem is

i have created nearly 25 tables in sqlserver management studio,

when i added sqldatabase(.mdf, .ldf files). i need add individual tables and save them.

which i feel is very risky task.

so i need a solution for export my whole database from "sqlserver management studio" to the "SQL database(.mdf, .ldf) file" in my current working project solution explorer.


frnds,
i think, i explained you clearly.

if there is mispells, sorry for that,

if any one of u guyz understand what i said above, pls reply to me

i'm waiting 4 ur reply.

ThanQs for ur patience........

praveen