SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DB Artisan


DB Artisan

Author
Message
Christopher Robin
Christopher Robin
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1233 Visits: 75
Anyone else using this product??? I am using version 8.1.2 and I have to say it is extremely comprehensive and is excellent in my shop where we have MS SQL Server, Oracle 8i & 10g, and DB2.



LJ-228252
LJ-228252
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 1

Yes, we are using DB Artisan for Sybase and have tried it for MS SQL Server too. It's a good tool.

We are currently considering Performance Center for proactive monitoring. Any experience or feedback on this product? Or any other recommended tools for Sybase & MS SQL Server environments?


Donald Wauchope
Donald Wauchope
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 13

I have been using dbartisan for about 4-5 years now thru various releases and consider it to be an excellent product. Pretty much able to get what I need done without resorting to running scripts. Find some bits to be confusing, but there is usually a way to get around most barriers. Also use ChangeManager is the best way I know of to keep database objects in synch.

Never had time to take in any training on the beast, but wish I did


Sopheap Suy
Sopheap Suy
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1269 Visits: 357

I have used this product for 5-6 years now and it is doing good. we have license for Oracle, Sybase and SQL Server. The maint things that we think is a problem is that it doesn't know how to handle SQL Server 2005. Well I am a SQL Server DBA so I don't use it againt any other product. With the new release license I heard it would be able to handle 2005 but there is another question about the license cost.

mom





Christopher Robin
Christopher Robin
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1233 Visits: 75
The latest release does indeed handle 2005. There were some questions about some late breaking changes to Vista and Longhorn which delayed things evidently.

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.



Markus
Markus
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3041 Visits: 3777
We have it here and have for about 4 years. We use it for minor SQL Server things, ease of use for some Oracle stuff and DB2 Unix admin. Some MF DB2 sometimes too. We really like it. I use it quite a bit for some things that Oracle Ent. Manager does not do... rebuild indexes on the fly... ease of use for modifying tbls... easier to add pri. keys/indexes too. Some dbs' that have a handful of schemas it is easier to analyze in Artisan.



TheSQLGuru
TheSQLGuru
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12653 Visits: 8562
I have actually been using their (embarcadero) products for many years now. I have become increasingly disappointed with their quality control over time. The latest versions I upgraded too have caused numerous problems for me and I had 6 bug reports within 2 months of using them. I cannot even use their products at one of my clients that has a lot of databases on a single server. And I ONLY do sql server, so their multiplatform capabilities are useless for me.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Karen Lopez @datachick
Karen Lopez @datachick
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 193

Just make sure you report the bugs to Embarcadero - the are normally incredibly responsive, so I'd be surprised if a bug report were ignored.

Karen


pveilleux
pveilleux
Old Hand
Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)

Group: General Forum Members
Points: 302 Visits: 1009
where did you hear about Performance Center being integrated with DB Artisan? I just did an evaluation of it and a comparison with Quest's Spotlight. It would seem silly to drop $20k on Spotlight if Performance Center is going to be free, even though IMHO it's an inferior product.
Carl Carter-348574
Carl Carter-348574
SSC Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 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).


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search