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:
Export:	HTML

2. Adminer

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

Commercial:	Free
Free edition:
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:
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:
Export:	GraphML,Image

DB Tools (edit)

DB Tools - @manhng

DBMS Tools - @manhng

1) DBeaver

dbeaver-ce-21.0.0-x86_64-setup.exe

2) Dataedo

Dataedo_Desktop_9.1.0_setup.exe

3) Convert

https://www.fullconvert.com/

4) SonarQube

https://www.sonarqube.org/forms/success-developer-edition/

https://docs.sonarqube.org/latest/setup/get-started-2-minutes/

https://docs.sonarqube.org/latest/analysis/scan/sonarscanner-for-msbuild/

http://localhost:9000/
U: admin
P: admin

Project: Test
Provide a token
Test: e2d74e6a4e7a188c3bc89021c1e3bd5398011669
The token is used to identify you when an analysis is performed. If it has been compromised, you can revoke it at any point of time in your user account.

C:\> SonarScanner.MSBuild.exe begin /k:"Test" /d:sonar.host.url="http://localhost:9000" /d:sonar.login="e2d74e6a4e7a188c3bc89021c1e3bd5398011669"
C:\> MsBuild.exe /t:Rebuild
C:\> SonarScanner.MSBuild.exe end /d:sonar.login="e2d74e6a4e7a188c3bc89021c1e3bd5398011669"

C:\> dotnet tool install --global dotnet-sonarscanner --version 5.0.4

You can invoke the tool using the following command: dotnet-sonarscanner
Tool 'dotnet-sonarscanner' (version '5.0.4') was successfully installed.

C:\> MsBuild.exe /t:Rebuild C:\Temp\Test.sln