CHANGELOG.md

Changelog

All notable changes to this project will be documented in this file. See standard-version for commit guidelines.

3.0.0 (2020-12-17)

Features

• add includeConstraintName config option (0235d94)
• add docker (c5545a7)
• add eol config option (a5ca82e), closes #7
• support both CLUSTERED and NONCLUSTERED INDEX, PERSISTED computed columns (#133) (d37ad0a)

Bug Fixes

• appveyor node version (9ccfe5a)
• build typing errors (7367c73)
• convert actions to async (8ad32f9)
• convert actions to async (829b501)
• convert actions to async (5593747)
• convert actions to async (a841aee)
• corrected data generation (#117) (e109f7d)
• download bak files to backups folder (4fa85ce)
• export names of default constraints (47eb83c), closes #81
• identity insert line break (b33b9c8)
• lint error (0e49aa6)
• port type should be number instead of string (#118) (69e9b2b)
• remove backups folder (4d7f71b)

2.1.1 (2019-01-23)

Bug Fixes

• skip job queries when no output (cba23cc), closes #65

2.1.0 (2019-01-16)

Bug Fixes

• deps: update dependency multimatch to v3 (#57) (25c1e78)
• add handling for no output root (1b80a3b), closes #60
• foreign key scripting (b47cdf5)
• indexes w/ multiple columns (9c18038), closes #48
• primary keys w/ multiple columns (3b0ef94)
• remove identity insert when no identiity (dbe7d33), closes #53
• update unit tests to work with node v11 (b7c4a93)
• user defined type scripting (1378a30)
• deps: update dependency tedious to v5 (#62) (01731bb)

Features

• add job generation to pull (14125e2), closes #31

2.0.2 (2018-10-09)

Bug Fixes

• write NULL for empty data values (#50) (2372554), closes #49

2.0.1 (2018-10-08)

Bug Fixes

• correct dependency issue (b5f66df)

2.0.0 (2018-10-08)

Bug Fixes

• convert objects to a valid safe filenames (2890512), closes #41
• deps: update dependency tedious to v3 (#44) (1f697b0)

Chores

• remove cat command (903f411)
• upgrade to classes (c4f0279)

Features

• add config option for commands (45c60ac)
• add data idempotency options (ad14985), closes #46 #47
• add file checksum comparison to reduce disk i/o (5946370)
• add prompt to push command (2573dc2)
• add support for data glob patterns (15cda32), closes #45
• consolidate output/idempotency options (81029fc)
• improve CLI output (5d36353)
• unify output formatting (69ac919)

BREAKING CHANGES

• Before:

"output": {
  "scalar-valued": "./functions/scalar-valued",
  "table-valued": "./functions/table-valued",
  "table-valued-parameters": "./user-defined-types/table-valued-parameters"
}

"idempotency": {
  "scalar-valued": "if-exists-drop",
  "table-valued": "if-exists-drop",
  "table-valued-parameters": "if-not-exists"
}

After:

"output": {
  "functions": "./functions",
  "types": "./types"
}

"idempotency": {
  "functions": "if-exists-drop",
  "types": "if-not-exists"
}

• remove cat command
• remove deprecated connection configuration option

1.9.1 (2018-09-14)

Bug Fixes

• deps: update dependency fs-extra to v7 (#35) (bb4a387)
• Fix foreign key scripting (#40) (c7a48ca), closes #39

1.9.0 (2018-07-07)

Bug Fixes

• remove column ordering by name (80fb9d7), closes #33
• pull: script computed field formula (2092150), closes #30

Features

• add connection config file support (#29) (ed92901)

1.8.0 (2018-06-11)

Bug Fixes

• deps: update dependency fs-extra to v6 (#24) (77cdbb1)
• deps: update dependency inquirer to v6 (#25) (65b047e)

Features

• add config to exclude output (9d6a21d)
• add data scripting to pull (#26) (d874206)

1.7.1 (2018-04-04)

Bug Fixes

• deps: update dependency fs-extra to ^5.0.0 (#20) (33813b6)
• deps: update dependency inquirer to ^5.0.0 (#21) (e61dfff)
• pull: correct table-valued parameters not exists idempotency (#23) (4c1df49), closes #22
• script indent inconsistencies (68b20da)

1.7.0 (2018-02-27)

Features

• add support for table-valued parameters (25d4c0d)

1.6.0 (2018-02-04)

Features

• add push command (a54bf6f)

1.5.0 (2018-02-02)

Features

• add update notification (cbc21c2)

1.4.0 (2018-01-13)

Features

• add conns command (a53d656)

1.3.2 (2018-01-13)

Bug Fixes

• properly handle relative root directory (#9) (a782fd1)
• remove duplicate schemas (056d58e)

1.3.1 (2018-01-11)

Bug Fixes

• pull inline-table value functions (#11) (dfdbfa6)

1.3.0 (2017-11-03)

Bug Fixes

• build error with chalk import (4c22e4a)

Features

• add schema scripting (32e75f7)

1.2.0 (2017-06-17)

Features

• add cat command (ec8e18c)

1.1.0 (2017-06-09)

Features

• add support for multiple connections (2319658)