Parse the text output of a MSSQL database export into JSON.
You can install the package globally and use it as command line tool:
# Using npm
npm install --global sql-db-schema-parser
# Using yarn
yarn global add sql-db-schema-parser
Then, run sql-db-schema-parser --help
and see what the CLI tool can do.
$ sql-db-schema-parser --help
Usage: sql-db-schema-parser [options]
Parse the text output of a MSSQL database export into JSON.
Options:
-i, --input <input> The input file.
-h, --help Displays this help.
-v, --version Displays version information.
Examples:
$ sql-db-schema-parser --input schema.sql
Documentation can be found at https://github.com/IonicaBizau/sql-db-schema-parser#readme.
Here is an example how to use this package as library. To install it locally, as library, you can use npm install sql-db-schema-parser
(or yarn add sql-db-schema-parser
):
const sqlDbSchemaParser = require("sql-db-schema-parser");
const schema = sqlDbSchemaParser.parse(`
table_name column_name data_type max_length precision scale is_nullable
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ---------- --------- ----- -----------
users email varchar 42 10 0 0
users first_name varchar 42 10 0 0
`);
console.log(schema);
There are few ways to get help:
- Please post questions on Stack Overflow. You can open issues with questions, as long you add a link to your Stack Overflow question.
- For bug reports and feature requests, open issues. ๐
- For direct and quick help, you can use Codementor. ๐
For full API reference, see the DOCUMENTATION.md file.
Have an idea? Found a bug? See how to contribute.
I open-source almost everything I can, and I try to reply to everyone needing help using these projects. Obviously, this takes time. You can integrate and use these projects in your applications for free! You can even change the source code and redistribute (even resell it).
However, if you get some profit from this or just want to encourage me to continue creating stuff, there are few ways you can do it:
-
Starring and sharing the projects you like ๐
-
โI love books! I will remember you after years if you buy me one. ๐ ๐
-
โYou can make one-time donations via PayPal. I'll probably buy a
coffeetea. ๐ต -
โSet up a recurring monthly donation and you will get interesting news about what I'm doing (things that I don't share with everyone).
-
BitcoinโYou can send me bitcoins at this address (or scanning the code below):
1P9BRsmazNQcuyTxEqveUsnf5CERdq35V6
Thanks! โค๏ธ