August 15, 2001 at 7:07 am
Brian, I liked your review of Datatect 1.6. I had been looking for some tool for quite a while to load data into a database just to simulate load and give a large enough sample to really run a server through the paces. My second delema always was I needed "real world" data to load into the database not just jiberish. Lastly, it is always hard to justify spending 1000 bucks on a small tool to my boses. Thats when I found Arg Database Populator v3.1. Its free it's pretty fast and it uses standard inserts to do all the loads. I have used it to pop databases up to 18 gb with real data. It's not as "feature rich" as datatect but it is free.
From the user guide:
"Quickly generates user-defined, meaningful but random data via ODBC.
Up to 100 tables each with up to 256 fields can be populated at a time.
Foreign key generation based on values in another table.
Customised counting sequences.
User-populated lookup tables for Names, Cities, etc.
Generates random Names, Address, Dates and Numbers, all user-configurable.
Data generation can be synchronised - titles match gender, towns match counties, etc.
Generates from 1 to 2 billion records per table. "
It does its job well. I suggest that if you haven't looked at it and you need a dataloader tool to check it out!
Wes
August 15, 2001 at 9:34 am
August 15, 2001 at 5:28 pm
I'll second that motion. Wes, if you've used it and are happy with it, we'd love to see a review of it. If you're interested email any one of us and we can give you details on how our publishing process works.
Note: This offer open to all our members - we're content and reader driven here!
Andy
August 17, 2001 at 7:41 am
I'd love to. I'm the king of cheap or free tools to do SQL work with. I also write lots of little tools to help out our day to day stuff.
August 27, 2001 at 5:51 pm
Where can I find this data loading tool?
Thanks!
Steve Armistead
Steve
Steve
August 28, 2001 at 5:13 am
Thanks Wes! I'd love to see the product. Could you post the URL? Free is always good!
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy