Hi,
I need to populate a database for a load-test.
I tried VS2005 for db proffesionals and it's datageneration plans, but it's
simply not working with the current configuration.
Do you know/use any other tool,preferable free, that can do this?
Thanks
Andre

andrea (a@a.a) writes:
> I need to populate a database for a load-test.
> I tried VS2005 for db proffesionals and it's datageneration plans, but
> it's simply not working with the current configuration.
> Do you know/use any other tool,preferable free, that can do this?

Which is because you use SQL 2000 RTM as was evident from another thread.
Install SP3 and try DataDude again.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

It's always worth a chuckle to see someone on an ms forum ask for a free
lunch -

www.rac4sql.net
www.beyondsql.blogspot.com

"andrea" <a@a.a> wrote in message
news:%23EOtfhQ5HHA.980@TK2MSFTNGP06.phx.gbl...
> Hi,
> I need to populate a database for a load-test.
> I tried VS2005 for db proffesionals and it's datageneration plans, but
> it's simply not working with the current configuration.
> Do you know/use any other tool,preferable free, that can do this?
> Thanks
> Andre
>

Well, I have two other available servers, running SQL Server SP3, but it
seems that I have a weird connection problem from the machine the VS2005
runs.
I have timeouts connectiong from VS as well making an ODBC connection.
All the machines are in the same network, so ot is not a network problem so
it is not so obvious for me what is going on with the different versions of
SqlServer.

Anyway, the best solution would be to obtain the generation scripts too - I
know maybe I want too much.

Thanks,
Andrea
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99954A559CC8Yazorman@127.0.0.1...
> andrea (a@a.a) writes:
>> I need to populate a database for a load-test.
>> I tried VS2005 for db proffesionals and it's datageneration plans, but
>> it's simply not working with the current configuration.
>> Do you know/use any other tool,preferable free, that can do this?
>
> Which is because you use SQL 2000 RTM as was evident from another thread.
> Install SP3 and try DataDude again.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx

> I need to populate a database for a load-test.
> I tried VS2005 for db proffesionals and it's datageneration plans, but
it's
> simply not working with the current configuration.
> Do you know/use any other tool,preferable free, that can do this?

not free, but certainly usuable with SQL 2000:
Advanced Data Generator at www.upscene.com



--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com