Truncating tables is out of the question as of now I think.

So what I did was (just for 1 DB), I generated the script from the Source and executed the script on the destination (I had created a DB prior) and after the script ran successfully, I had pretty much all the objects except the data. Now I have to do it for 700+ DBs and I don't want to do it manually. Any advice on that.