| Last updated: 17 March 2013 |
|
|
Sybase-related WWW links
|
| |
|
This page has some links to useful information about ASE or Sybase.
Please note that, insofar these sites promote any products or services, the presence of links to these sites on this page does not constitute an endorsement of those products or services by Rob Verschoor/Sypron B.V. (with the exception of the Sybase products, which I do endorse).
Categories
Frequently requested Sybase reference documents
These are links to some Sybase reference documents that will answer many frequently asked questions:
-
A new whitepaper describing the feature known as 'Compatibility Mode', which is included in ASE version 15.0.3 ESD#1 (released March 2009).
-
The new "ASE 15 Optimizer Best Practices" whitepaper: a must-read when you're upgrading to ASE 15.
Other documentation sources
Some other places where you can find useful information about ASE:
-
White Sands Technology, Inc. has published two whitepapers about data fragmentation and database corruption. Although these whitepapers are oriented towards some of White Sands' own products, they also contain some useful general information.
-
Poster of ASE system tables (PDF format)
At the following links, a number of documents can be downloaded. One of these is a PDF
document of a system tables poster for ASE.
Don't bother about if the language isn't yours: all table/column names are still in English.
To get a printed copy, call your local Sybase
office and try to order it; the part number is
70204-01-1250-03 for ASE 12.5 and 70204-01-1502-01 for ASE 15.0.2 (both English versions).
-
Poster of RepServer system tables (PDF format)
At the following links, a number of documents can be downloaded. One of these is a PDF
document of a system tables poster for Replication Server.
Don't bother about if the language isn't yours: all table/column names are still in English.
Query tools
ASE comes with the query tools isql (ASCII, all platforms), SQLAdvantage (GUI, Windows only) and -in ASE 15.0- dbISQL (GUI, Java-based). For those who are not satisfied with these tools, there are some alternatives :
-
"sqsh"
(a great isql replacement):
http://www.sqsh.org
An ASCII query tool for ASE. "sqsh" is much better than isql -- in fact, some DBAs say they cannot work without
sqsh anymore. For sqsh tricks, go here.
-
iSQL-Viewer:
http://www.isqlviewer.com/
iSQL-Viewer is a free GUI query tool with some really handy features that can be used with ASE as well as other databases. It's JDBC-based and runs on Windows, MacOS and Linux.
-
Aqua Data Studio:http://www.aquafold.com/
A Java-based freeware GUI query tool for ASE as well as many other databases. Note that more recent versions appear to require licensing.
-
"Orac": http://www.tux.org/orac-dba/
Orac is a multi-platform, multi-database aware, open source database administration tool written in perl/Tk. Despite the name, there's no inherent association with Oracle behind this.
-
Thomas Gagne's 'is' tool:
http://gagne.homedns.org/~tgagne/
This tool is another isql replacement. It can return a result set as HTML or XML (also as plain text), as well as read the ASE login name & password from a cookie. It works well, but you'll have to compile it yourself - YMMV.
Miscellaneous tools
Some useful ASE-related tools (these are all located on external websites; for some tools located at www.sypron.nl, go here):
-
Nicolas Gouteux' SQL Browser, http://www.sqlbrowser.com
SQL Browser is a development/debugging tool for ASE stored procedures. As one of its features, it can automatically check for SQL constructs that must be changed when migrating to ASE 15.
-
Brad Wery's QweryBuilder, http://www.werysoft.com
Brad Wery(of TeamSybase) has created a database development tool that supports -among others- ASE.
-
Ed Barlow's Generic Enterprise Manager (GEM):
http://www.edbarlow.com
Ed has created an enterprise management tool -- probably the first to provide such functionality for ASE installations.
If I were still a DBA, I think I'd want to have this.
Recommended. (Oh, and it supports MS-SQL as well).
-
http://www.sqleffects.com
SQL Effects have a product called "SQL Effects Clarity", which lets you compare database schemas; it supports all versions of ASE.
Sybase ASE vs. other DBMSs
For those ASE DBAs who are unable to avoid that other database brand...
-
Sybase ASE 15 vs. MySQL 5.0 performance comparison
http://www.sybase.com/detail?id=1045499
Describes comparitive TPC test results between ASE 15.0 and MySQL 5.0. A useful document if you need ammunition in favour of ASE.
-
http://www.psoug.org:80/reference/sybase.html
Warning: this page is NOT recommended. It may look like a comprehensive Sybase-to-Oracle comparison, but it's so full of factual errors that it's basically useless. For example, it is stated that 'SQL Server runs only on Windows' and that ASE doesn't have an equivalent of bulk insert. Even the Oracle side of this reference isn't fully correct. The author also seems to have mixed up Sybase ASE, SQL Anywhere and Microsoft SQL Server.
News, information and user forums
For keeping in touch with the rest of the world...
-
Sybase-related newsgroups exist at Sybase's own
news server: forums.sybase.com
The public newsgroups are a great place to ask your questions. These forums are followed by Sybase engineers and TeamSybase members (among others), so there's a good chance of getting the right answer to your question.
 By the end of March 2013, the public Sybase newsgroups at forums.sybase.com will be closed down. This is the result of the acquisition of Sybase by SAP in 2010, and the forums are moving to SAP's Community Network (SCN) at scn.sap.com. You need to register before you can post questions at SCN, but this is free & easy (see http://scn.sap.com/docs/DOC-18437).
For most Sybase users, the new location is http://scn.sap.com/community/sybase-adaptive-server-enterprise/content. This is part of the SCN community for non-SAP users of ASE.
For users of SAP applications (e.g. SAP Business Suite) that run on Sybase ASE, there is a separate community, and its forums are at http://scn.sap.com/community/sybase-ase/content.
When moving to SCN, the existing messages in the NNTP newsgroups will not be migrated. You can still access and search the collective history via Google Groups, or via http://nntp-archive.sybase.com.
(NB: the classic Usenet newgroup comp.databases.sybase has little traffic anymore these days)
-
ISUG (International Sybase User Group):
http://www.isug.com
You should become an ISUG member if you're not - it's great value for money.
- Discussion Forum about SQLBacktrack
Though not restricted to ASE users, here's a new site with a discussion forum about SQLBacktrack. It's located at http://sqlbacktrack.eu.tt.
-
Team Sybase (those friendly guys who answer all your questions in the newsgroups at news://forums.sybase.com). Also contains info about these newsgroups.
Miscellaneous links
As the title says....
- Lev Selector's web site,
http://www.selectorweb.com/
Contains useful pointers for various IT-related topics. I often use this site when looking for info about something...
- Pal's
Linux RDBMS Library,
http://www.palslib.com
Various links to resources about RDBMS and Linux
stuff... as the name suggests.
Sybase resources (non-English)
Blogs
-
http://blogs.sybase.com/database
The old location of my blog at sybase.com. The Sybase blogs have been closed down at the start of 2013 and moved to SAP SCN (see above).
Podcasts
Books
Please follow this link to my page about Sybase-related books.
|
|
