Last method is fetching random value from an other table within the same database. Second way is using random integer values within a parameteric data range where you can set the lower boundary and the upper boundary for the random integer values. To generating test data for integer data, tool supports three methods.įor all methods if column is nullable, it is possible to set null column values in percentage as NULL fill factor.įirst method is using incremental value for the column test values beginning from a parametric seed number and using an incremental step. There is not a combo box or a list where you can select a database among available sql databases. One simple point in the database connection screen is you have to manually enter the database name. MS SQL Server (6.5, 7, 2000, 2005, although it is not in the list can connect to SQL2008)Īlthough MS SQL Server 2008 is not in the database connection list, I connected to MS SQL2008 using the MS SQL 2005 option successfully. Here is the databases listed in the database connection screen :
DATABASE DATA GENERATOR GENERATOR
One important advantage of DB Data Generator is that it can connect to a large number of databases. I want to take short reviews of this test data creation tool here and share my product reviews with you. Since I have been working recently on test sql data generator tools SQL Server testers would like to use in my company, I have download and installed the DB Data Generator tool from Datanamic.
SQL Database developers can generates meaningful test data for SQL Server using Datanamic DB Data Generator Toolĭatanamic is company creating tools for SQL Server and for other common databases in order to make it database design and database development easier for database developers and administrators. SQL Data Generator Tool Datanamic for Test Data Creation
0 kommentar(er)
