I currently use the **Visual Studio Professional Edition** which has the database project as a project template, but some of its features are not available, for example **Schema Compare tool**. The schema comparison and database update scripts generation are only available in **Visual Studio 2010 Premium/Ultimate versions**.

But are the schema comparison and update scripts generation features in the Visual Studio as rich as those in **Redgate SQL Compare tool**? (I didn't use it either) I didn't manage to find the feature comparison list. Could anybody, who used both of them, help to make it clear?