Database sampling for testing and demo

2015-11-18 Thread Stuart Kinnear
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

2015-11-18 Thread DotNet Dude
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

2015-11-19 Thread Grant Maw
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.
>>
>> -
>>
>
>