@manhng

Welcome to my blog!

DBMS Tools

February 21, 2022 14:32

DBMS Tools (edit)

DB Tools - @manhng

DBMS Tools - @manhng

Generate logical models and entity relationship diagrams easily from an existing database with Oracle SQL Developer Data Modeler.

Document Entities (oracle.com) (Oracle Diagram)

.NET Framework Data Providers - ADO.NET | Microsoft Docs

60 Database diagram / Reverse Engineering tools for Oracle - DBMS Tools

ADO.NET - ADO.NET Data Providers (hiepsiit.com) (Tiếng Việt)

Open Planning - Hướng dẫn lập trình (Tiếng Việt)

TRẦN VĂN BÌNH MASTER: Trang chủ (tranvanbinh.vn) (Tiếng Việt)

Meet Guru99 – Free Training Tutorials & Video for IT Courses

Oracle Vs. SQL Server: Key Differences (guru99.com) (Tiếng Anh)

  • Entity Relationship Diagram (ERD)
  • ER Modeling
  • Entity Data Model (EDM)

.NET Framework Data Provider

  • .NET Framework Data Provider for SQL Server
  • .NET Framework Data Provider for OLE DB
  • .NET Framework Data Provider for ODBC
  • .NET Framework Data Provider for Oracle
  • EntityClient Provider
  • .NET Framework Data Provider for SQL Server Compact 4.0

.NET Data Provider

  • Microsoft ActiveX Data Objects (ADO)
  • Microsoft ActiveX Data Objects for .NET Framework (ADO.NET)
  • Open Database Connectivity (ODBC)
  • Java Database Connectivity (JDBC)

1. SchemaSpy

SchemaSpy is a Java-based free and open source tool that generates interactive entity-relationship diagrams to HTML from database schema metadata analysis.

Commercial: Free
Free edition: Yes
Export: HTML

2. Adminer

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP.

Commercial: Free
Free edition: Yes
Export: SQL script

3. DB Designer Fork

DB Designer Fork is a fork of the fabFORCE DBDesigner 4. It integrates entity relationship design, front-end (you can run queries), and SQL exporting

Commercial: Free
Free edition: Yes
Export: SQL script

4. DatabaseSpy

DatabaseSpy supports all popular databases:

  • Firebird
  • IBM DB2®
  • Informix®
  • Microsoft Access™
  • Microsoft® Azure SQL
  • Microsoft® SQL Server®
  • MySQL®
  • Oracle®
  • PostgreSQL
  • Progress OpenEdge
  • SQLite
  • Sybase®

5. DBeaver

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts.

Commercial: Free
Free edition: Yes
Export: GraphML,Image

Categories

Recent posts