Fantastic. I think using the BACKUP and RESTORE method is going to work, otherwise I'll look into creating an SSIS package. You guys have been a big help.

Thanks,

-Dave

BACKUP and RESTORE would be would perfectly, something along the lines:

use master

backup database project1 to DISK='C:\DatabaseBackup.bak'

restore database project1_dcarrigg from DISK='C:\DatabaseBackup.bak'

The problem (as you might have already noticed) is that each...

I've thought about that same thing, and we're currently use ApexSQL DataDiff for doing just that.

The issue with this is that now it's a manual process that a DBA needs...