Hi Andy, thanks for your reply. In between I found a solution that works well, but as more objects and processes involved so I think I will try your approach...

Hi,

what about dumping (backing up) the database(s) and restoring it on the target server. Certainly not as fast as the bcp approach but much easier. You can simply set new directories...