Sybase client Tool

Source: Internet
Author: User
Tags sybase sybase client

Although I have been away from the Sybase project for a long time, today a colleague suddenly asked me what Sybase client tools were used, but I don't remember what tools were used every day, I found the name of the software for half a day on the Internet, so that I can make a small summary here to avoid further difficulties.

The following tools are commonly used at the time. They have their own advantages and disadvantages. If you are interested, you can study them in depth. Here I will only list the differences between my most commonly used functions.

1. Sybase SQL advantage: I installed 12.5.1 and can only run SQL to query data. You can use Sybase export commands to export the entire database and insert and modify data using SQL only, you can view the table structure like a PL-SQL.

Official Sybase Central: You can only view data and table structure in the form of views. You can view table creation statements. You can modify field attributes in the view directly, but cannot insert and modify data. You can operate on SQL advantage.

2. dbartisan: you can connect to multiple databases. You need to set the character set when connecting to Sybase. You can view the table structure and table data in view mode. You can easily export the entire database and insert statements for a single table, you can also export the table creation statement, in view mode to modify the table data will automatically generate the corresponding SQL statement like a PL-SQL, overall, this software function is very comprehensive.

3. toad for SYBASE: toad is a powerful database client software, but each database has an independent software. I prefer toad for Oracle, which is very convenient to use, it is also very powerful and useful for database management. With a preference for toad for Oracle, I would like to try toad for Sybase, it is not as easy to use as for Oracle only after download and installation, and it is not very convenient to export a single table. Unlike for Oracle, you can right-click the table to export data, I did not find it, but it still has the same features as for Oracle, that is, it can easily insert, modify and delete data in view mode, because the operation is complicated, no further research.

The above is my commonly used Sybase client software. If you only want to view the data, you can directly use the official Sybase Central. In fact, we recommend the second software, because the common functions can be implemented directly or indirectly, which is sufficient for the development and maintenance work at ordinary times.

The above is my personal opinion. If you have any different opinions, you are welcome to discuss them together.

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.