all groups > sql server reporting services > december 2004 >
You're in the

sql server reporting services

group:

general mock (fake) database creation approach ?


general mock (fake) database creation approach ? Frank RS
12/22/2004 10:53:02 AM
sql server reporting services:

Hello, friends and gurus. May I have some advice on general approach you
guys take to generate a mock database with fake data in it?

Thanks

--
Re: general mock (fake) database creation approach ? Jeff A. Stucker
12/22/2004 2:12:17 PM
If you have real data available, you can scramble the data (especially
names) to make demo data. Otherwise, it's just a lot of work. There are
lots of options. Randomize. Get some other data source and pretend it's
what you want. Refactor census data. Get imaginative.

--
Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
[quoted text, click to view]

Re: general mock (fake) database creation approach ? Tim Ellison
12/22/2004 4:19:03 PM
Frank,

I don't know if this will help or not, but what we have found that works
well is use stored procedures that return "fake" data; at least enough to
return data that will suffice for formatting, grouping, etc.

[quoted text, click to view]

AddThis Social Bookmark Button