If you take a look at the below screenshot you will see the basic functions and capabilities of the EMS Data Generator for SQL Server. You can also configure only date test data generation excluding the time part by clearing the "include time" checkbox. Generation of random datetime test data for SQL Server datetime and date columns is very easy using this sql tool for data generation. Developers and testers should find some other ways to build XML test data for their test cases. Note that XML data type is not supported in this tool for SQL Server. In the help documentation there is some mask examples for web addresses, mask for email addresses, for vehicle numbers etc. But I think the mask utility is not advanced for complex data creation.įor example I could not create a string of lower and upper cases mixed with additional Turkish characters. I tried to create mask for string values. So practically using a test data with only letters used in Turkish alphabet can not be managed simply using the CharSet combobox. SQL developers or sql testers can also limit used characters with in the charset using the Start Char and End Char selections.īut since the Turkish characters are not listed in order after the A.Z, I had to let many unwanted characters while identifying the end character. What I liked in the EMS Data Generator for SQL Server is that it can create random data using different chractersets.įor example, while creating test data for Firstname field in AdventureWorks database dbo.Authors table, a developer can select latin5 (ISO 8859-9 Turkish) chracter set for example. I assume that is a small bug for a sql data generator tool. In this case, the databases are not listed but the previous list of available tables are still the same. The problem occurs when I return back to SQL Server connection screen and select local SQL Server instance for generating test data. The "Available Tables" list is populated with tables created on this sql database. One small detail with EMS Data Generator for this test data tool is the table list is not refreshed in case of an unexpected case.įor example I successfully connected to a SQL Server, then select a database from the available sql databases created on the SQL instance. So I used the above work-around for the local server which I will create test data using this sql data generator tool. ![]() Though EMS Data Generator seems to connect to my local SQLServer 2008 instance successfully, it was unable to list the databases loacated on my SQL2008 database instance. So the work-around for connectiong to a local named instance is connecting the local server by selecting remote server option and entering the name of the server with the named instance.įor example instead of connecting to local SQL Server named instance ".\SQLExpress" select "remote server" option and enter the SQL Server name in the format "Kodyaz\SQLExpress". In this textbox you can enter named instance SQL Server on remote servers. The host name dropdown list is activated only when you choose the remote SQL Server connection type. When you select "local" server, you do not have an input area where you can enter the name of the SQL Server instance you want to connect to. ![]() One note on this screen, it does not support local named instances for SQL Server. In this first screen of tool SQL Server connection properties can be configured by identifying the SQL Server as local or remote, selecting the authentication type and entering the sql login name and password. So first I tried to connect to MS SQL Server 2008 instance local on my computer.įirst screen of the sql test data generator tool is for configuring sql server connection properties. This enables me code free from development SQL Servers since sql data is with me. ![]() I generally install SQL Server instances on my development computers in order to develop code any where I'm at home, at office or while I'm mobile. I'm developing an ASP.NET application where data is stored in a Microsoft SQL Server 2008 database. In this short SQL product review for EMS Data Generator for SQL Server, I'll try to share my experience with this sql test data generator tool SQL Server developers and testers would like to use. Create SQL Test Data Using EMS Data Generator for SQL Server
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |