Where is it possible to form an ER-scheme based on the existing database structure?

Question

PHP

Unloaded the DB structure from MS SQL Server 2012. There is a need to look in some CASE tool for the ER schema. Please tell me what kind of software you can use.

Answer 1

Well, what about the controller? They wrote to you:
Look for where you lost this class.

Answer 2

It is necessary in SecurityPlugin.php, which is located in app/plugins (if memory serves), to register the page (controller and action(s)) in the ACL parameters.
If you need to make the page available to everyone (public) - ~59 line :

$publicResources = array(
  'index'      => array('index'),
  'about'      => array('index'),
  'register'   => array('index'),
  'errors'     => array('show401', 'show404', 'show500'),
  'session'    => array('index', 'register', 'start', 'end'),
  'contact'    => array('index', 'send'),
  'test'       => array('index') // Как-то так: test указывает на TestController, index - на indexAction     
);

If the page should be available only to registered users (private), do the same in $privateResources ( ~48 line ):

$privateResources = array(
  'companies'    => array('index', 'search', 'new', 'edit', 'save', 'create', 'delete'),
  'products'     => array('index', 'search', 'new', 'edit', 'save', 'create', 'delete'),
  'producttypes' => array('index', 'search', 'new', 'edit', 'save', 'create', 'delete'),
  'invoices'     => array('index', 'profile'),
  'test'         => array('index') // Вот, как-то так:)
);

Good luck!

Answer 3

Sybase PowerDesigner was creditable at one time (while I could use it for free;))
In general, the score of such software is dozens: https://en.wikipedia.org/wiki/Comparison_of_data_m...

Answer 4

https://pgmodeler.io/support/docs/52-import-a-database
https://erwin.com/products/erwin-data-modeler/
Erwin used in conjunction with Oracle, but it was a long time ago

Answer 5

You can build a chart in SSMS.