dbdesigner - Developer IT

Problem with DBDesigner

- by Renato Bezerra

Hi everyone. The DBDesigner can synchronize only with MySQL? I tried with SQL Server but don't works. DBDesigner Ver: 4.0.5.6 Tks.

DB Designer creates compound primary key

When adding relationships to a database model in DB Designer 4, a composite primary key is being created every time. So every foreign key I add, I get an extra key added to a composite primary key. I think I must have changed a setting as I don't remember it doing this in the past. Does anyone know how to turn off this feature as I prefer to use a single surrogate primary keys in my database tables?

Read the article

Is there any er diagram tool in Windows that I can use to connect to a MySQL 4.1 database in Unix?

- by melaos

I have a few test databases in some Unix SUSE 8 servers and initially the plan was to find some tools which can directly create the ERD straight from the server until someone told me that I can find tools to connect from the Windows PC straight to the Unix MySQL database. So I saw MySQL query analyzer which can do this but unfortunately there are no options to create an ERD. So are there any tools, preferably open source or free which can do this? I've done some basic googling but didn't know what is the exact terms to use to search for this and have so far found nothing useful yet. Updates: I just found out that the latest version of workbench doesn't work MySQL 4.1 Enterprise Edition which is the version that I have! And I try to use fabFORCE DBDesigner but I can't even connect at all using that one :( What can work for this version of MySQL?

Developer IT