ApexSQL Generate creates test data for columns as well as tables. It exports test data in SQL, XML, and CSV files, or runs in conjunction with the database. Utilize a range of predefined options for customizing the data. For instance, you can set the length, seed as well as the max and min values. It also lets you set the as well as the uniqueness of data, as well as the percent in null value. Check the generated data prior to execution or exporting. With ApexSQL Generate you can easily create million of rows of testing data. Make use of different generators, such as Random Incremental, Incremental, From list from directory, From table From query as well as From CSV. It is intelligent in auto-creating patterns of data at the row level. It can handle an array of types of data, such as money, geography and hierarchies.
ApexSQL Generate is a great tool for everyone SQL Server developers who need to ensure that their applications run smoothly and are seeking test data.
The application is able to run on any computer that have .NET Framework 4.5 is installed, and it can be used with Microsoft SQL Server 2005 or higher, as well as Azure SQL Database.
In order to make the most of this application users must first link it up to a database that is compatible by choosing the server type and authentication method. Users can also create the names of aliases if they want to keep a specific configuration for the future.
When making a new project you can also specify how many rows are required, turn off the INSERT trigger and CHECK constraints or alter your seed's value.
ApexSQL Generate supports multiple types of data creation, and users can experiment with each one until they find the one they like best.
