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.
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: