![]() ![]() Below demonstrates how you can very quickly generate data for the Northwind database.Īfter loading the application, you will be presented with a Project Configuration dialog. Northwind is one of the sample Microsoft databases originally shipped with SQL Server 2000 and is used in a very large number of articles, as such it seemed logical to use it for this post. My favourite generator is the C# Code Generator created by Lionel, allowing you to write and compile C# code directly within the UI to use as the column generator. We already have a few online for you to download and use so I strongly recommend you take a look. On a side note, we have created a CodePlex site to host all any generators created by the community. If you have any comments or questions, please let us know via the forums. We are really looking forward to hearing what you think in order to make the best possible product. To prove this, see below for how I used the application to generate data for the Northwind database. From a DBA’s point of view, the tool is great for performance and scalability when huge amounts (millions of rows) is required to test against. We feel it’s a great tool and is really useful during test and development, it’s just a great tool to have in order to quickly fill your database. SQL Data Generator intelligently creates meaningful test data by automatically taking the table and column names in to account, along with field length and any existing constraints. 1022 builds later, today, we (Red Gate) released SQL Data Generator which is available to download as a 14 day trail. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |