wise-coders / dbschema

DbSchema Database Designer
https://dbschema.com
67 stars 3 forks source link

Suggestion: Assign Group to Table Externally #81

Closed NeilN1 closed 1 year ago

NeilN1 commented 1 year ago

It's be helpful if I could:

  1. Export a list of tables on the current layout and their groups to a text file
  2. Allow someone else to edit the group assigned to each table
  3. Import the text file which would update table groups and auto-arrange the diagram accordingly.
wise-coders commented 1 year ago

Why should you do this using a text file, instead of doing it directly visual in DbSchema? I need to understand this feature request.

NeilN1 commented 1 year ago

If you have many tables, it may be better for business analysts (who don't have access to the tool, only exported diagrams) to decide what groups to have and which group each table belongs to rather than the DBA.

wise-coders commented 1 year ago

I suggest two solutions here:

  1. let the business analyst also use DbSchema, without database connectivity. They can work on the model file.
  2. Use automation scripts to implement custom logic. Check Tools / Automation scripts using Java.