Well obviously I need to catch up on DTS. Dave Ross pointed out to me that there is an option for "copy objects and data" that is a part of the DTS wizard. I never tried that option. I simply didn't absorb what it said. In my head I had the 3 options separated as
Having tried it I can tell you it does a perfectly wonderful job of copying the data, views, stored procedures etc. There is even an option to eliminate the object level permissions (like owner). And it doesn't generate constraint errors because it's smart enough to copy the objects and data in an appropriate order. Thanks Dave - you just saved me some time - even if I have to eat crow (ha).