Modules
Deploy higher-quality SQL Server applications, faster
Best Practices
Improve SQL code smells with best coding practices reviews and enforcement
- Integrate with SSMS and Visual Studio
- Seamlessly integrate into your CI/CD process
- Review databases and individual SQL scripts
- Process unattended via the CLI
- Leverage a library of 100+ pre-written rules
- Write custom rules in C# or VB.NET
- Import and export rules
- Create custom rules with a built in IDE
- Create HTML reports and XML exports
Builds
Create a SQL database from any input; automate builds from source control
- Create executable installation packages
- Consolidate multiple SQL scripts
- Ensure error free deployments
- Deploy databases directly from SQL source control
- Build databases from scripts, source control, etc
- Preview the script impact by action or SQL object
Data transfer
Import and export SQL Server data to different file types
- Export data to 13 different file types and from multiple tables/views at the same time
- Pre/post scripts when importing/exporting data
- Import data into SQL Server from different files types
- View full import and export process summary
- Variety of import mode types such as append, update etc.
Generation
Generate random test data for SQL Server
- Generate SQL test data for specified tables and millions of rows quickly
- Export test data to SQL, XML, CSV, JSON, Excel
- Customize test data plan with detailed options
- Support a full range of SQL data types
- Choose from multiple generators (Random, List, etc.)
- Retain data consistency with foreign key support
- Emulate real-world test data
Scripting
Generate DDL and DML SQL script output and execution packages
- Script both SQL database objects and data
- Script objects directly to a source control project
- Integrate with all popular SC systems e.g. Git, SVN
- Save customized scripting profiles as projects
- Create executable installation packages
- Automate SQL database scripting and migrations
- Script an entire server down to individual columns
- Easily decrypt some/all encrypted database objects
Unit Testing
Implement SQL unit testing directly from SSMS
- Integrate SQL unit testing directly into SSMS
- Install and manage tSQLt from multiple sources
- Create and organize test classes
- Automate test execution using the CLI
- Create and organize unit tests
- Write tests using T-SQL
- Run tests with a single click
- Manage all tests with a single form
By the way, I want to let you know that the ApexSQL tools have become indispensable to us. They have worked flawlessly from day one and have saved us a huge amount of time and effort. Really nice software
Steve Bernat | President | Izonim, Inc.
Body