Using Sybase Central

Sybase Central is the utility for managing Sybase servers. It's a graphical interface written in Java so you need to make sure your Java runtime is installed and ready to use.

Start by logging in as the sybase user...

and then run scjview (usually found in /opt/sybase/sybcent41/bin (where 41 is the version number). This should bring up the main Sybase Central window...




The first thing you'll wish to do is to connect to the database. Pulling down the Tools menu and selecting Connect brings up the connection dialogue...




The default user for any new installation is 'sa' (system administrator) and, by default, the password is blank. The Server name will default to the name of the host machine, typically LOCALHOST if you haven't set anything else. If you enter the information and click OK, your new server will appear in the left hand pane. Double click on the server to bring up a list of all the facilities in the right hand pane...




Selecting any item in the right hand pane causes the item to be opened and the right hand pane's tree to be moved to the left hand pane. As you work, a complete tree builds up in the left hand pane so that you can use any of the tool's facilities at any time.




Central provides facilities for creating and managing databases, tables, views, and stored procedures. It does a great deal more than that as well, allowing you to define where physical data is stored, connect to remote servers, manage caches and a number of other things.

A complete description of what Central can do would take up a lot of space so the best thing to do is run it up and use it.  There's a reasonably good online help facility which is worth consulting if you run into difficulties.

Find out more by searching Google here...