Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

DB Artisan Expand / Collapse
Author
Message
Posted Tuesday, June 26, 2007 4:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 5, 2009 2:51 AM
Points: 31, Visits: 15

I work for a major investment bank and we use DBArtisan on Sybase ASE to an extent.   It does the job very well but is one of the buggiest apps I've ever used, (even compared to Windows :p).  We (developers) have been barred from using it on production databases as it does such a bad job of handling errors - leaving code running when it should've been cancelled - code still running when you're not even in the application anymore etc.

That combined with pretty poor GUI mgmt (have you ever clicked on a button on DBArtisan and it doesn't capture the click but you end up clicking on a window which is behind DBArtisan!?!?!) - it's quite an interesting concept lol.  Not to mention the guaranteed crash whenever you close the application down.... clean exit anyone?  Never with DBArtisan. 

All said and done, it's still a brilliant tool and I put up with the above annoyances and use this instead of isql / SQL Advantage and I don't generally use much of the other fancy functionality within the tool (Performance centre etc which I think someones already mentioned).

 

 

Post #376563
Posted Sunday, July 8, 2007 5:41 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 10, 2014 11:52 AM
Points: 1,197, Visits: 63

I got the information from my sales guy at Embarcadero after a quarterly meeting happened.  If you look at DB Artisan you will notice that the different views in the application are actually web pages and it makes even more sense.  The word from Embarcadero at the time was that was the direction the engineers wanted to move in so don't be surprised if you see Performance Center disappear sometime in the coming years.

I have SpotLight from Quest but I have found it to be less than what I need (really, none of those monitors does what I need) so I fell back on DB Artisan and multiple monitors on my desktop which gives me the best of both worlds.  I am in the process of discontinuing my license(s) from Quest it works so well.




Post #379823
Posted Monday, July 9, 2007 11:26 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 10, 2014 8:13 AM
Points: 1,278, Visits: 2,204

I have used it for nearly 5 years (SQL server 6.5/7.0/2000/2005 and Sybase). Some features are pretty handy.  But the history report part is not as good as they advertised.  

SQL server 2005 has some build-in features/functions which are much better than 3rd party tools.

Post #380154
Posted Friday, November 2, 2007 1:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 21, 2007 1:39 AM
Points: 1, Visits: 6
Christopher Robin (5/5/2007)
Performance Center was an option we looked at, however, I received information that Performance Center will most likely be wrapped up inside DB Artisan in the relatively near future so took a pass on that product.


I think your information may be either outdated, or a rumor.
Performance Center is still a product on its own (in fact the 2.0.3 release is pending - with support for DB2 v9 as the main adding) and I don't think it will be integrated inside DBArtisan in the next 24 months.

Cristian Amarie
Performance Center development team
Post #417794
Posted Thursday, July 9, 2009 12:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 25, 2010 9:37 AM
Points: 3, Visits: 22
I have a real love/hate relationship with DBArtisan. On the one hand, there's nothing like it for useful features. On the other the bugs are embarassingly bad. I'm currently running 8.5.5 to which I upgraded because the earlier version would scramble source code in the editor, an utterly unforgivable bug. The new version is less buggy, but I really have to wonder what the Embarcadero developers are smoking because I'd be ashamed of being associated with it. In additions to bugs others have mentione, here are a couple of my "favorite" examples:

The editing keys (copy, insert, etc.) are inconsistent between windows. Need to copy some code out of a stored procedure window into an iSQL window? Ctrl-C doesn't work in the source code window. It does everywhere else. Moreover, this changed from the earlier version. Get this right and lock it down. Don't go all Microsoft by "improving" basic function from version to version.

Speaking of editing, if you want to copy some results out of an ad-hoc query so as to insert it into Excel, well, that's hit-or-miss. Sometimes you get the data in columns, sometimes you get it as concatenated strings. I could be doing something wrong but, somehow, I doubt it.

Don't try search and replace in a script extract window. That results in an endless loop behavior with shutdown the only option.

Would it be too much to ask to put a Copy selection on the right-click context menu? Jeez, everyone else does this why not DBArtisan?

Then there's the incredibly useful data unload and load feature. I'm not being sarcastic here, it's damned useful. But I've learned the hard way not to dump to comma-separated files, the load feature can't read them!

I live in a Sybase world and while I actually like Sybase (don't even ask me about the miserable Sybase GUI tool, it's even worse), I long for the stability of the new SQL Server Management Studio. Compared to DBArtisan, it's rock-solid.

These issues may seem small, but when the query you've been tweaking for the last hour is lost in some window that's now inaccessable because DBArtisan has lost it, one tends to become very upset very quickly.
Post #750563
Posted Friday, July 10, 2009 8:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 12:58 PM
Points: 39, Visits: 30
I agree as far as the love/hate aspect. Every upgrade we do is to get a fix to a major bug in the current version. We are now upgrading to 8.6.1 because of bugs in 8.5.5 related to DB2. We use DBArtisan for Sybase, SQL Server, DB2, and Oracle.
Post #751131
Posted Friday, July 10, 2009 8:51 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 8:43 AM
Points: 417, Visits: 1,157
I have been using DBArtisan for many years. Currently I am using version 8.6.1 for Oracle and SQL Server. I find it more useful of the Oracle databases than for the SQL Server databases I manage. The feature I use most is the process monitor which I find has more useful information and has a clearer format than SSMS.
Post #751135
Posted Monday, July 13, 2009 12:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:29 AM
Points: 2,720, Visits: 1,564
Am using the latest Embarcadero DBArtisan 8.5.5 currently and have had this tool for couple of years. Works very well to manage our Sybase but i would stick to using SSMS to manage SQL Server. Prior to this current version, found out that certain objects were not displayed in DBArtisan due to the tool unable to recognise special characters but SSMS is displaying everything fine.

Reckons you should be a bit careful when drilling deep into SQL via DBArtisan. But so far, been happy with the tool (unless you're willing to manage a bunch of Sybase via isql )


Simon Liew
Microsoft Certified Master: SQL Server 2008
Post #751809
Posted Tuesday, October 27, 2009 9:35 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 23, 2014 9:31 AM
Points: 79, Visits: 231
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?
Post #809408
Posted Monday, April 22, 2013 12:59 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 12:58 PM
Points: 39, Visits: 30
This is an old thread, but the comments still ring true. We use DBArtisan 8.6.1 because it was the least buggy version I came across. We use SQL Server Management Studio as well as Rapid SQL and TOAD. RDBMSs supported include Sybase, DB2, Oracle, and SQL Server.

We are trying to find an open source alternative to DBArtisan. Anyone know of such a product?
Post #1445120
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse