SQL Server Express Starter Schemas
The SQL Server Express team got Barry Williams from http://databaseanswers.org to publish 10 pre-built schemas for common database designs to help ease the pain of working with databases and for users to understand what real-world database schemas look like. This helps in that rather than you having to recreate the wheel, you can take and modify these designs and use them as a good start place. Each design comes with create and drop scripts, a pre-built MDF database, and a corresponding ER diagram.
- Data Schema 1: Assets Maintenance
- Data Schema 2: Contact Management
- Data Schema 3: Customers and Orders
- Data Schema 4: Document Management
- Data Schema 5: e-Commerce
- Data Schema 6: Help Desk
- Data Schema 7: Issue Tracking Software
- Data Schema 8: Retail Inventory Control
- Data Schema 9: Not for Profits
- Data Schema 10: Product Catalogs
SQL Server Hosting Toolkit
The ASP.NET team has published a Database Publishing Wizard designed to easy the pain of getting a SQL Server Express database you created locally onto a web hoster like GoDaddy and others.
Scott Guthrie has a great tutorial that walks through step-by-step on how to publish your database.