DBGen or other database generator tool

[divinyl]

Hi all

I need to start doing some process testing for an upcoming project that will involve administering a VLDB and am looking for a database generator tool. I've started playing with DBGen (off the sql 2000 resource kit) but what i need to be able to do is divide the data amongst a few filegroups and DBGen doesnt appear to support this. Could i possibly be overlooking an option or does someone know of another more flexible tool that would allow data distribution across filegroups?

Thanks

Div

 

[divinyl]

Nevermind - i didnt have the right understanding about this. Distributing tables across filegroups is done within SQL prior to using DBGen. When using DBGen you then specify what tables you want to populate. I understand this now...

Div