how do I re-duplicate sql server database ?

Question

I would like to stress test my database, which is a hospital patient database.

The current one is 2 GB. I would like to have a 100GB database, so I would like do the following:

1) read each patient record 2) create a new, fake patient id, and store back to database 3) repeat until size reaches 100GB

What is the easiest way of doing this? Are there tools for this?

Thanks!

Answer 1

Are you familiar with SSIS? If so, you can change your PK to add a 2G value to make it unique, then copy all the rows from your source table back to the same table as the destination.