Pros -
Integrates well with SQL Server 2005.
Allows you to generate scripts with foreign keys too.
Allows you to alias columns and also pass in defaults.
Allows to assign security permissions
Cool looking wizard.
Cons -
The trial version allows only Insert and Get All functonality.