>You could just script the structure and then move the data by maybe linking servers or work out you own data segments and select those out into temporary tables etc

We can't bypass the firewall on that one. It seems I will have to break that big script into dozens of scripts and upscale them one by one into a new master table.