ApexSQL Generate vs Benerator
ApexSQL Generate
apexsql.com
Benerator
benerator.deSide by side
| Figure | ApexSQL Generate | Benerator |
|---|---|---|
| Price from | — | Free |
| Free plan | — | Yes |
| Free trial | Yes | — |
| Open source | — | Yes |
| Web | — | Yes |
| Windows | Yes | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | — | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 0 | 4 |
| Spec score · Test Data Generation Tools | 8.0 (#5) | 9.1 (#1) |
| Automation | ApexSQL Generate can save selected project settings as batch or PowerShell automation scripts. | The product page says data processes can be integrated into GitLab CI or Jenkins. |
| Database support | The listed requirements include SQL Server 2005 and higher, Azure SQL Database, and Amazon RDS for SQL Server. | The documentation lists examples for Oracle, DB2, Microsoft SQL Server, MySQL, PostgreSQL, HSQL, H2, Derby, and Firebird. |
| Purpose | ApexSQL Generate populates SQL databases with test data using multiple generators for each column. | Benerator generates, anonymizes or pseudonymizes, and migrates data for development, testing, and training. |
| Support | Quest states technical support is available to customers with valid maintenance contracts and trial users. | Community Edition issues can be reported through GitHub Issues; premium customers can contact support by chat, contact form, email, or phone. |
Plans
Benerator
- Community EditionFree
- EnterprisePriced on request
- LightPriced on request
- ProfessionalPriced on request
In their own words
ApexSQL Generate
ApexSQL Generate has no write-up on Specifiction yet; its figures are above.