2007/06/11

Shrinking your Visual Web Developer project databases

It's annoying that my web app's SQL Server 2005 database file is less than one megabyte in size; whereas the internal application database created by Visual Web Developer, with which I've never mucked directly, is over 10MB.

Of couse the blogosphere has known about this problem much longer than I have. And here's a handy solution:

Shut-Up and Smile : ASP.NET Membership Database Squish

This script does the equivalent of the SQL Server Management Studio's "Tasks->Shrink" menu item. I have a hard time using that menu item on my application's database file, perhaps because of file ownership issues. Whatever: this script smooshed things right down to size.

No comments: