Re: How to create a small test db from a huge db.
- From: Scott McDaniel <scott@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 27 May 2007 16:19:57 -0400
On Thu, 24 May 2007 03:15:01 -0700, Larou <Larou@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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.
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@xxxxxxxxxxxxxxxxxxxxxxxxx
www.infotrakker.com
.
- Prev by Date: Re: sql server stored procedure
- Next by Date: Import Format Help
- Previous by thread: Re: sql server stored procedure
- Next by thread: Import Format Help
- Index(es):
Relevant Pages
|
