Thursday, March 29, 2012

Export Empty Database

This is kind of a elementary question, but how do you export an empty copy of a SQL 2005 database to a backup file? Basically I need a backup without any of the data. Thanks!what you want is just the scripts for the objects then.

you can use GSW for this, or this console app: http://www.codeplex.com/scriptdb|||I think I already accomplished this using SQL Management Studio. Is that all I need?|||yea, that works. that's what I meant by GSW - "generate scripts wizard" in ssms.

No comments:

Post a Comment