ApexSQL Generate vs Chance.js
ApexSQL Generate
apexsql.comChance.js
chancejs.comSide by side
| Figure | ApexSQL Generate | Chance.js |
|---|---|---|
| Price from | — | Free |
| Free plan | — | Yes |
| Free trial | Yes | — |
| Open source | — | — |
| Web | — | Yes |
| Windows | Yes | — |
| API | — | Yes |
| Self-hosted | Yes | — |
| Plans published | 0 | 1 |
| Spec score · Test Data Generation Tools | 8.0 (#5) | 8.3 (#2) |
| Data types | It supports SQL data types and can recognize column types in a loaded database to generate corresponding test data. | Its generators cover items including text, people, locations, dates, finance, and web-related values. |
| Purpose | ApexSQL Generate populates SQL databases with test data using multiple generators for each column. | Chance generates pseudo-random strings, numbers, and other values for automated tests and other uses that need random data. |
Plans
In their own words
ApexSQL Generate
ApexSQL Generate has no write-up on Specifiction yet; its figures are above.
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.