Database sampling for testing and demo
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. -
Re: Database sampling for testing and demo
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 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. > > - >
Re: Database sampling for testing and demo
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 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 > 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. >> >> - >> > >