SQL Data Extractor

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.