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. If you need to generate credit card numbers you might want to try this other tool.Create SQL Test Data Using EMS Data Generator for SQL Server If you find that you like the tool and would fancy more features, or even just for regular feedback, don't hesitate in telling me at. you can only save/load one structure at a time). I've created this because I needed something like it and hadn't found it before. Hit "Load recipe" whenever you come back and your structure will be waiting for you. When you've created a table structure that you think you might want to keep while you play with the tool or even one to come back to on another day, just hit "Save recipe". You might have to wait a bit if you select a high enough number though. You can also generate as many rows as you wish by inserting the desired number on top-right input called "Generated rows".
Return to the homepage and select "Full Custom" or add columns by clicking "Add another column", to represent your table schema. Select a table structure from the default list and hit "Generate data" to see an example with 10 rows of fake data. Generating fixtures has never been easier. This is an attempt at making the problem smaller. Manually inserting 3 or 4 rows in each table just isn't good enough. Both of these situations benefit from having a large body of data that is semi-coherent (so you can kind of inspect it) but that is automatically generated. You might test it for correctness and you might test it for load.
When developing an application, you would be wise to test it.
Why do I need to fill a database with random data?