how do I re-duplicate sql server database?

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!

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.