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

DB Tools

March 5, 2021 17:45

DB Tools (edit)

DB Tools - @manhng

DBMS Tools - @manhng

1) DBeaver


2) Dataedo


3) Convert


4) SonarQube




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



Recent posts