The Professional Edition gives you all the tools to implement the full DB Ghost Process enabling you to script out your databases into individual DROP/CREATE scripts, place those scripts under source control, modify them there and then build and deploy from those scripts.
Scripts all object types into individual DROP/CREATE scripts Scripts data into boilerplate INSERT scripts Command line or API execution for total process automation in daily/continuous builds etc. (requires Automation Toolkit?) Can add scripts to source control (VSS only) Builds databases from individual object scripts Highlights syntax, dependency and data errors Creates a single script for the database build that can be reused Can synchronize two databases making them match precisely Can synchronize an existing database to a set of base schema creation scripts in your Source Management System. This means that your Source Management System itself provides a complete audit trail Can insert custom scripts at the end of the build, before and after the synch process Creates a script of the differences between two databases or base schema scripts and a target database Handles all types of database object and all complex interactions Intuitive, straightforward wizard based interface SessionSave facility lets you save your wizard answers for later reuse