|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL 2005 Resource Kit - DBGen?Hi all
I need to generate a load of test data for an upcoming project and came across the DBGen tool in the SQl 2000 resource kit. I'm wondering if there's a new version in the 2005 resource kit? If not, will the 2000 version work ok in sql 2005? Also - does anyone know how I can get ahold of the 2005 resource kit? Thanks, NB It may still work but you might want to check out the CTP of Datadude that
has a data generator instead. http://blogs.msdn.com/euanga/archive/2006/08/23/711713.aspx -- Show quoteAndrew J. Kelly SQL MVP "Neile Bermudes" <NB@community.nospam> wrote in message news:97C03AB8-9B20-4FC0-9377-0F48D0938C7D@microsoft.com... > Hi all > > I need to generate a load of test data for an upcoming project and came > across the DBGen tool in the SQl 2000 resource kit. I'm wondering if > there's > a new version in the 2005 resource kit? If not, will the 2000 version work > ok > in sql 2005? > > Also - does anyone know how I can get ahold of the 2005 resource kit? > > Thanks, > NB Thanks - i will look into this as it may be more flexible than DBGen. Just
one other question on DBGen - i think the answer is no, but will it allow me to divide data across existing filegroups? When we go live our VLDB will be distributed across multiple filegroups so its important that our test environment reflects this, and from what i can see, DBGen does not have this functionality. Am i missing something? Also - does someone know of a tool that will allow this functionality? Perhaps this Datadude product? Thanks NB Show quote "Andrew J. Kelly" wrote: > It may still work but you might want to check out the CTP of Datadude that > has a data generator instead. > > http://blogs.msdn.com/euanga/archive/2006/08/23/711713.aspx > > -- > Andrew J. Kelly SQL MVP > > "Neile Bermudes" <NB@community.nospam> wrote in message > news:97C03AB8-9B20-4FC0-9377-0F48D0938C7D@microsoft.com... > > Hi all > > > > I need to generate a load of test data for an upcoming project and came > > across the DBGen tool in the SQl 2000 resource kit. I'm wondering if > > there's > > a new version in the 2005 resource kit? If not, will the 2000 version work > > ok > > in sql 2005? > > > > Also - does anyone know how I can get ahold of the 2005 resource kit? > > > > Thanks, > > NB > > > Data from a single table or index can not span filegroups just files. The
data goes into the filegroup where the table lives that you are inserting into. So if you want to make use of multiple filegroups you need to design your schema appropriately. -- Show quoteAndrew J. Kelly SQL MVP "Neile Bermudes" <NB@community.nospam> wrote in message news:A57725B4-CDA4-4AFB-9E80-317FD4B63694@microsoft.com... > Thanks - i will look into this as it may be more flexible than DBGen. Just > one other question on DBGen - i think the answer is no, but will it allow > me > to divide data across existing filegroups? When we go live our VLDB will > be > distributed across multiple filegroups so its important that our test > environment reflects this, and from what i can see, DBGen does not have > this > functionality. Am i missing something? > > Also - does someone know of a tool that will allow this functionality? > Perhaps this Datadude product? > > Thanks > NB > > "Andrew J. Kelly" wrote: > >> It may still work but you might want to check out the CTP of Datadude >> that >> has a data generator instead. >> >> http://blogs.msdn.com/euanga/archive/2006/08/23/711713.aspx >> >> -- >> Andrew J. Kelly SQL MVP >> >> "Neile Bermudes" <NB@community.nospam> wrote in message >> news:97C03AB8-9B20-4FC0-9377-0F48D0938C7D@microsoft.com... >> > Hi all >> > >> > I need to generate a load of test data for an upcoming project and came >> > across the DBGen tool in the SQl 2000 resource kit. I'm wondering if >> > there's >> > a new version in the 2005 resource kit? If not, will the 2000 version >> > work >> > ok >> > in sql 2005? >> > >> > Also - does anyone know how I can get ahold of the 2005 resource kit? >> > >> > Thanks, >> > NB >> >> >>  |
|||||||||||||||||||||||
Other interesting topics