Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I have an ER diagram within Sybase Central (for SQLA11), which I have arranged into something approximating a useful representation of my DB. I now want to pass this diagram onto my team so they can continue editing this, but am having some issues ...

I have filed a support case in the past to migrate a diagram from SQLA 10 to 11, which involved editing the contents of the file at the following location:

C:\Documents and Settings[username]\sybase\Sybase Central 6.0.0.scUserPreferences600

to import the line:

Profiles/sqlanywhere1100/SystemDB_ERDiagramLayout= ... where SystemDB appears to correspond to the database name of my DB when served.

However, copying this line to another machine does not seem to show the ER diagram correctly.

Does anyone have any experience with this, or knowledge of other things I might have to edit in this file??

Otherwise, what do other people use to draw ER diagrams?

Thanks!

asked 10 Jan '11, 14:43

Adam%20King's gravatar image

Adam King
2255513
accept rate: 0%

No answer from me, but I'm certainly interested when if it pops up.

(10 Jan '11, 22:49) Siger Matt
Comment Text Removed

No solution to your problem, but an answer to your last question: we use PowerDesigner to draw ER diagrams (came with SQLA). PD can import the structure of a database and create a physical model from that. From model changes we generate an update script to deploy the modifications to dozens of databases.

(11 Jan '11, 12:37) Reimer Pods
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×128
×2

question asked: 10 Jan '11, 14:43

question was seen: 2,784 times

last updated: 10 Jan '11, 14:43