Thanks Lowell, tried them procedures but they fail with an error, cant remember which, will try again and post.

Want to try and avoide DAC as it kicks everyone out and we are on a but of a tight schedule to get a piece of work out the door so cant impare the developers at the moment.

As all environments share the same schema, for now I have just backed up and restored test onto dev for the DB's in question and used the import export wizard to create a extract package to pump the data from R2 to R1.

If there are problems with the above looks like I will have to put in a few late nights using DAC to script out the objects.