dbDoc / dbDiagram - I love it

Ask the Community
1

Started using dbDoc and dbDiagram few days ago.

My company bought Informatica MDM (not going to post the price here but lets say it cost me an arm and a leg and my firstborn) . With dbDoc and diagram i can do 80% of the work we are doing with MDM tool.

Next step is to upload our entire data model 10 data bases and around 3K tables. Any advice on best practices.

Jay

1 Like
2

Hi Jay,

Glad to hear you’re seeing that much value already! Scaling to 3,000 tables across 10 databases requires a bit of strategy to keep things snappy. Here are two best practices:

  • One Database per Project: I highly recommend splitting each of your 10 databases into its own separate project/file. This significantly optimizes performance and prevents “schema bloat.”
  • Use Diagram Views: Within each database, use Diagram Views to scope tables by domain (e.g., Finance, Users, Logistics). This gives you a much smoother UX by letting you focus on specific modules rather than 300+ tables at once.

Since you’re dealing with such a large scale, automation is your friend. Setting up a CI pipeline to push these updates will save you a ton of manual effort as those 3k tables evolve.

Best Regards
Huy Phung