By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,964 Members | 1,810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,964 IT Pros & Developers. It's quick & easy.

Copy schema of all tables and procedures from a database in SQL SERVER 2008

P: 7
I would like to copy script/schema of all the tables and stored procedures of a database and restore it in the database on client machine. But I don't want to copy DATA of database. Because, I have test data in the database on my development machine and don't want to copy this data on client machine.

This can be done manually by right clicking table and selecting "Script Table As >> CREATE TO", but it is a manual process and time consuming.

Is there a way copy all the table and proc schema at once WITHOUT coping actual DATA.

Thanks in Advance.
Apr 30 '13 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072

Post your reply

Sign in to post your reply or Sign up for a free account.