All of the larger databases that I have to tune are scientific in nature - so I can usually take some other investigation as input, and rescale it and add jitter. I am very sorry if this is a common question, I am working first time in SQL real time scenario. I typically generate my own, using some known data as input - if its too random, its not always a good test I need data thats going to be distributed similarly to my final product. Create large volumes of meaningful test data with no. If you have an existing database, then you can use BCP to export the table data, and then use SDG to import. If you already have some dummy test data, SQL Data Generator can load that from a text or CSV file. With the column-intelligent data generation, the data in one column is based on the data of another. Your first task is to use the SQL Data Generator’s GUI to design a strategy for filling each of the tables in your database with data. Tip Make sure you have admin privilege before creating any database. It provides great flexibility and manual control over the creation of the foreign key data. How it Works Just enter your 'Database Name' to the input above and select collate then click to the button 'Generate' and you will get your MySQL query. Is there any script or any other solution to perform this tasks in simple way. Data Generator includes 200+ meaningful SQL data generators with sensible configuration options. One more thing I found in Google is red-gate tool can be used.IRI RowGen, for multiple DBs and flat files, uses Eclipse GUI. Found in Google that SQL profiler will provide the order of execution, but waiting for the access to analyze this. If you cannot find a free version, RedGate produce a commercial one called SQL Data Generator. Currently I am planning with the possibilities to create dummy data in excel, but here I am not sure the relationships between the tables. SQL Data Generator Database Testing Generating Realistic Test Data Creating a Simple Development Harness with SQL Compare and SQL Data Generator There is no single, correct approach to developing and testing your SQL batches and routines.In SQL server is there any way to insert this much data insertion possibility. To insert that much dummy data into the tables, I need to understand the application completely in very short span so that I don't have the dummy data also by this time. I gone through the tables and there is relationship between all the tables actually. Currently development team is done their application, and as a tester needs to insert 1000000 records into the 20 tables, for performance testing.
0 Comments
Leave a Reply. |