Chance.js vs Redgate SQL Prompt
Chance.js
chancejs.comRedgate SQL Prompt
red-gate.comSide by side
| Figure | Chance.js | Redgate SQL Prompt |
|---|---|---|
| Price from | Free | $17.50/mo |
| Free plan | Yes | — |
| Free trial | — | Yes |
| Open source | — | — |
| Web | Yes | — |
| Windows | — | Yes |
| API | Yes | — |
| Plans published | 1 | 3 |
| Spec score · Test Data Generation Tools | 8.3 (#2) | 7.5 (#18) |
| Integrations | The documentation includes installation and usage instructions for Bower and RequireJS, as well as npm for Node.js. | SQL Toolbelt Essentials adds integrations with SQL Dependency Tracker and SQL Compare. |
| Intended users | The site gives generating random names and addresses for automated tests as an intended practical use. | Redgate describes SQL Prompt as a productivity add-in for SQL Server developers working in SSMS or Visual Studio. |
| Purpose | Chance generates pseudo-random strings, numbers, and other values for automated tests and other uses that need random data. | SQL Prompt is an add-in for SQL Server Management Studio and Visual Studio that completes, formats, analyzes, fixes, and refactors SQL code. |
Plans
Redgate SQL Prompt
- SQL PromptPriced on request
- SQL Prompt$210 a year
- SQL Toolbelt Essentials$1,410 a year
In their own words
Chance.js
Chance.js is a free, MIT-licensed JavaScript library for generating pseudorandom data used in automated tests and other applications needing sample values. Generators cover basic values, text, people, mobile identifiers, web data, locations, dates, finance, helpers, and miscellaneous categories. Developers can install it with npm for Node.js, load it in a browser, or use the separate chance-cli package from the command line. Browser users may create a global instance or instantiate several instances. Supplying a seed makes output repeatable; instances given the same seed can produce the same sequence. Integer generation accepts inclusive minimum and maximum bounds, and the unique() helper builds arrays without repeated generated items. The documented name generator supports English and Italian nationality options. The site lists chance.js at 95KB uncompressed and chance.min.js at 55KB, or 17KB gzipped. Chance is not intended for cryptographic applications requiring true randomness. The site credits Victor Quinn as its writer.
Redgate SQL Prompt
Redgate SQL Prompt has no write-up on Specifiction yet; its figures are above.