Search code examples
sqldatabaseschemasybasesqlanywhere

Sybase Schema Model with mapped relations

I want to create schema model with mapped relations of Sybase database.

Database based on SQL Anywhere 9.

  • What's the best method?
  • Could I generate schema model "on the fly" based on database structure with some auto scan?
  • Or I should create it manually?
  • What software I should use, some dedicated by Sybase or some another tool?
  • Once when I will create this schema model, how to easy keep it updated?

I need this schema model, to keep better documentation of the database, because actual database structure is very complicated and database is very very huge.

Solution

  • SAP Sybase Power Designer is a good tool for visualizing, developing and maintaining databases. It supports all the SAP Sybase databases, as well as other commercial RDMBS's (SQLServer, Teradata, DB2, etc).

    PowerDesigner