How to create a small test db from a huge db.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a db that in total has 35million records. However, these have been
broken down into 5 different files. This still makes it very difficult for me
to make any progress on working with them.

I want to create a new, smaller db and fill it with a random selection of
records from one of the 5 huge db's first. Then crerate the Quries and Forms
that I can then run on the bigger ones.

Any help would be much appreciated.
 
I have a db that in total has 35million records. However, these have been
broken down into 5 different files. This still makes it very difficult for me
to make any progress on working with them.

I want to create a new, smaller db and fill it with a random selection of
records from one of the 5 huge db's first. Then crerate the Quries and Forms
that I can then run on the bigger ones.
Click to expand...

How do you want to select your "random" records? You can use the TOP keyword in an INSERT INTO or SELECT INTO query to
move records from one file to another ... this wouldn't be truly random since it would always get the first xxx records,
but you could use various ORDER BY clauses to change the order of the recordsets.

With 35 million records, it sounds as if archiving might be in order, unless you have some pressing need to query this
many records for day-to-day operations (and you may very well have).

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Back
Top