There used to be some data generation tools in Visual Studio some years back. These were dropped after VS2010 IIRC. A shame, because they were very useful for exactly this sort of thing.
On 19 November 2015 at 16:44, DotNet Dude <adotnetd...@gmail.com> wrote: > We used to write scripts to do this manually back in the day. > Someone just said there may be a tool from redgate also. > > > On Thu, Nov 19, 2015 at 5:07 PM, Stuart Kinnear <stu...@skproactive.com> > wrote: > >> When testing an application that uses a database it is desirable to test >> it with data similar to production in volume or structure. >> >> Our client's databases are getting large and also it would be useful to >> munge it according to a set of formulas eg. swap people's names against a >> master source of name entries, change values according to some formula. >> >> I've come across a product called Jailer ( >> http://jailer.sourceforge.net/home.htm) which promises to extract data, >> and ApexSQL have a product called SQL test data generator ( >> http://www.apexsql.com/sql_tools_generate.aspx). Haven't as yet tried >> them. >> >> I was wondering what others are doing in this area. I'm after a product >> that is fuss free and doesn't take a rocket scientist to set up and >> maintain. >> >> -- >> >> ----------------------------------------------------------------------------- >> Stuart Kinnear >> Mobile: 040 704 5686. Office: 03 9589 6502 >> >> SK Pro-Active! Pty Ltd >> acn. 81 072 778 262 >> PO Box 6082 Cromer, Vic 3193. Australia >> >> Business software developers. >> SQL Server, Visual Basic, C# , Asp.Net, Microsoft Office. >> >> ----------------------------------------------------------------------------- >> > >