SqlDataExtractor 0.1.1
dotnet tool install --global SqlDataExtractor --version 0.1.1
This package contains a .NET tool you can call from the shell/command line.
dotnet new tool-manifest # if you are setting up this repo dotnet tool install --local SqlDataExtractor --version 0.1.1
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=SqlDataExtractor&version=0.1.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
nuke :add-package SqlDataExtractor --version 0.1.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
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.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net7.0 is compatible. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
This package has no dependencies.