You can point to a database on your local machine, and then automatically create a sql script file. This sql script includes everything needed to create the database data and schema (tables, views, sprocs, triggers, full-text catalogs, roles, rules, etc) . It's a painkiller future that you find very useful when publishing applications to remote machines.