For a combined SQL developer and DBA there's one tool (outside of the package supplied with SQL Server itself) that does everything I have found I need and that is SQL Management Studio by EMS. The software is wicked. Compare and synchronise data structures between dbs, compare and synchronise data, import, export, manage indices, backups etc. etc.
It's worth every penny and I now rarely use SQL Server tools themselves. BIDS is a different matter of course - it's essential for SSIS and SSRS.