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