>Hi,
>
>I need to generate 20 million records in a table in a database in order to make some realistic testing situations. I created some VFP code which created about 4.5 million records but this took about 5 hours. I am now trying some SQL code to SELECT the top 1000 records and insert them back into the table (with new GUID primary key) and looping many times, but this is going pretty slowly too.
>
>What would you all suggest? Would selecting all 4.5 million and inserting them back into the table be faster? And then maybe do that again a few times?
Did you consider BULK INSERT a disk file?
----------------------------------
António Tavares Lopes