I am currently working with a production database that has exceeded the original estimations. In an attempt to limit or stay on top of the tables created, I have created several users with limited privilages. The only problem is, the developers have created several temp and junk tables within their own schema that are entirely too large.

What is the best way to set up a development environment to allow testing prior to populating the production database?

Several of the main tables used in processing contain over 50 million records and counting......