Database Extractor

a Database Structure and Query Export Tool

This is a Go application designed to query tables, views, and their dependencies from a Microsoft SQL Server database and export the retrieved structure data into various formats such as JSON, XML, and markdown files.

Features

• Query tables and views from one or more specified databases.
• Export the queried data to JSON, XML, or markdown files.
• Handle dependencies between tables and views.

Prerequisites

• Go programming language installed on your system.
• Access to a Microsoft SQL Server database.
• Configuration file (config.yaml) specifying the server details, user credentials, and databases to query.

Installation

1. Clone this repository to your local machine:
2. Navigate to the project directory:
3. Build the application:

go build

Usage

1. Ensure you have configured the config.yaml file with the necessary server details, user credentials, and databases to query.
2. Run the application with appropriate command-line flags:

• -config: Path to the configuration file (default: config.yaml).
• -output: Output type (options: json, xml, files, debug).
• -cached: Use cached data if available (options: true, false).

3. The application will query the specified databases, export the data based on the output type, and either write it to files or log it for debugging.

Configuration

The config.yaml file contains the following configuration options:

server: "mssql.example.tld"
user: "john.doe"
password: "$ecret£assw⌀rd"
databases:
  - "Sales"
  - "Purchases"
  - "Customers"

• server: The address of the Microsoft SQL Server.
• user: Username to authenticate with the server.
• password: Password for the user.
• databases: List of databases to query.

Contributing

Contributions are welcome! Please feel free to open issues or submit pull requests to improve this application.