Loading

move,attach,detach sql expres database

kassim

i am using local database in my application development,i want to create new database with same exisitng database schema
i want to add functionality such as new,export,import database

how can i create blank database files using existing database schema
aur move physcial db file from one location to another location

i am using sql server express databas (.mdf) files

how can i accomplish
please prove detail steps

2 Replies

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

kassim17y ago
dude that script will create database of same name, and for that sql server managment studio is required,

at the time of deployment i'll just put local database on target machine
i want d function so that user can create new database every year, a blank db but with existing schema and fifferent name
or i just want to use datbase schema as template for creating database
Lalit M17y ago
Hi,

You can use script wizard to crested blank data base show this link you may get some idea.