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 <[email protected]> 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. > > ----------------------------------------------------------------------------- >
