Sybase client Tool

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.