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. |