Is it possible to create a copy of entire database, not the data, but just database structure?

greetings community,

this question related express edition.

let’s have mydatabase2014 , i’ve been populating data during year 2014. before end of year, want prepare database named mydatabase2015, should empty, of course should have tables, relations, indexes , stored procedures mydatabase2014. idea change connection string , continue using same app same job.

so in ssms, right-clicked database, choose script database / create / new query, didn’t wanted. in query window i’ve got create database statement, , below few dozen of alter database set ansi or statements, , set many other things. however, no table creation scripted. also, no stored procedures have been created, , users, , other security objects better not start talk about.

i have achieved right-clicking databases node , select new database. what’s point of “script database as”?

does work in sql server editions other express?

when comes express edition, what’s best practice empty copy of database?

thanks help.

hi ivica

try using generate , publish script wizard doing this

right click on database > tasks > generate scripts option

you should able select required objects script them out here

hope helps

thanks

bhanu

SQL Server  >  SQL Server Express