Recommend a good database tool Embarcadero DBArtisan

Source: Internet
Author: User
Tags db2 db2 database client

The DB2 database has been used in recent projects because the DB2 database client is not very convenient in terms of operation and control, such as the writing of stored procedures. Later, our operations in the database were transferred to the Dbartisan, the latest version seems to be 8.12.
Here's how it's convenient to use this tool:
When writing stored procedures can use the wizard to complete, use very convenient, for example, we first select the database schema (owner), enter the name of the stored procedure, click Next

is the language used to select the Write stored procedure (SQL for example)

Then click Next, such as:


Enter some of the input and output parameters you used in the stored procedure here.
And then freak out the next step:


For example, between Begin and end is where we write SQL statements.
Once you have written the stored procedure, click "Create" above to create a stored procedure.
Although the convenience of this method of writing stored procedures in SQL Server may not be reflected, but in the DB2 is greatly reflected.
Second, DBArtisan8.12 the biggest advantage is that he supports debug, as if in 7.1 does not support Debug.
Is the stored procedure I have written, click: "COMMAND" select "DEBUG ..."

For example, enter the parameters of the stored procedure after the point "Continue"

For example: Press F11 to debug the stored procedure we write, which is very useful in some complex stored procedures.

Third, fully support data Field Association, which is also one of the advantages of Dbartisan.
Let's take a look at the Lenovo feature of Dbartisan Query Analyzer, taking SQL SERVER2005 as an example.
First connect the DBA tool to SQL SERVER2005, create a new query, and look at:

Multiple selections can be made on the associated field.

Is it feeling very good ah! ~~~~~dbartisan8.12 supports most of the current databases.
However, DBArtisan8.12 also has a very bad place, that is, the editor to write stored procedures for Chinese support is not very, do not know that I did not configure the reason, or other reasons.
DBArtisan8.12 can find the registration machine on the Internet, as if the use is not very good, I have DBArtisan8.12 license, the need for friends can be sent to you.
License download

Recommend a good database tool Embarcadero DBArtisan

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.