How I can add 1000 records to a database? Is there a program to add names and numbers at randomly?

Answer 1

I highly recommend using this site for generating sample data:

http://www.benjaminkeen.com/software/data_generator/

The site allows for generation of a variety of fields (names, numbers, email addresses, passwords, etc...). If it doesn't have an exact field that you want, you can generally use a combination of the supported fields to get what you want.

Another site to consider is:

http://www.random.org/

I tend to favor the first one but pick the one that best suites your needs.

As for how to add 1000 records to a database, I'd look at using a control file to load the records (easy to do in Oracle, not sure about other databases but can't imagine it to be too difficult).

If you require non-English names, there are a few sites that can help with generating international names (don't have links for them readily available but you could search Google for name generators and probably find them). You can then manipulate the data to merge back with any numbers you generate and then prepare the file for loading into the database.

Answer 2

I think a SQL Command can add records to your database.

Answer 3

Depends on the database. There's usually a way of appending data.

Answer 4

It's not that difficult to generate script to add your records. For example if you're using T-SQL you can write a few lines script using a WHILE loop to insert your records.

If you feel this is difficult, you can code few lines in a client application using whatever language you feel comfortable to insert your records.

Answer 5

which programming language do you use ??

Answer 6

usually, we create our 'data generator', but you can try this software :
http://www.sqledit.com/dg/
http://www.sqlmanager.net/