Skip to content

Latest commit

 

History

History
49 lines (30 loc) · 1.79 KB

README.md

File metadata and controls

49 lines (30 loc) · 1.79 KB
Raw

SQL Data Extractor

Build

SQLDataExtractor is a .NET CLI tool that provides functionality for extracting data from SQL databases.

Features

  • Schema Extraction: Extracts the types, functions, tables, indexes, and constraints from a database whilst keeping the correct dependency chain.
  • Row Extraction: Extracts rows from a table whilst maintaining referential integrity.

Supported Databases

Schema Extraction Row Extraction
MySQL ❌ ❌
PostgreSQL ✅ ✅

Getting Started

Installation

Install the dotnet CLI tool and run the following command.

dotnet tool install SqlDataExtractor

Usage

Make sure to add the dotnet tools folder to your system/shell's PATH. Some example commands are shown below:

# Extract 5 rows from the `users` table
sde extract-rows --connection "$DbConnection" --schema "$DbSchema" --table users --limit 5

# Extract a database schema
sde extract-schema --connection "$DbConnection" --schema "$DbSchema"

Contributing

We welcome contributions to SqlDataExtractor!

To get started contributing, you could raise an issue and provide enough details for us to investigate the issue.

You could also make changes to the project by forking the repository, creating a branch with the proposed changes, and opening a pull request in this repository.

You are always welcome to buy me coffee to keep me going.