I've been using DBArtisan for years; currently for SQL Server 2005 only. The main use is for generating scripts to be deployed at customers' sites, such as table change scripts, multiple stored procedure extracts, etc.
As some others have mentioned, I've found it to be great when it works, but also extremely buggy. I'm using an old version (8.1.4) because every new version I try is unusable due to critical bugs. I recently installed 8.7.0 and quickly logged six bugs. So I'm stuck using 8.1.4.
To me it seems like they do little to no QA on these products. That sounds harsh, but some of the bugs are unbelievably obvious and critical.
Question 1: Can any of you recommend an alternative product?
Question 2: Our developers use Embarcadero's RapidSQL, which also has its share of bugs. I'm thinking of phasing that out and instead just using SQL Server Management Studio. Does anyone have an opinion about that?