Reverse Engineering Trouble Shooting


Reverse Engineering a database is a complicated task. As such it requires many pararmeters on the client and the server to be configured correctly for it to function.

System Table Permissions

Reverse engineering in some cases requires the application to access System Tables in the DBMS. The reverse engineering output log will usually display these errors. The user must ensure they have read access to these tables.

In particular, MS Access will require the user to have read permissions on MSysObjects, MSysRelationships.

See: MS Access Permissions

MySQL TimeStamp Columns' NULL Incorrect

In reverse engineering TimeStamp columns from MySQL they will erroneously come back as NULL when in fact they were specified as NOT NULL.

Reverse Engineering from SQL Server Doesn't Reverse Engineer Comments

DbWrench reverse engineers the extended properties of tables and columns as comments only if they are named 'Comment' (case insensitive). DbWrench also forward engineers comments as extended properties named 'Comment'.


See also:

Reverse Engineering