Generate create script of a existing database , without data - SQL Server 2008
Is there a feature in sql server 2008 management studio to generate database create scripts from existing database开发者_Go百科 without data and with all the relationships maintained.
Yes, of course.
Go into: Tasks
> Generate Scripts
Then,
in Choose Script Options
set Scrpit Data = False (default)
In SSMS, right click the db and select "Script database as Create to"... whatever you want
精彩评论