>This is good way, but we may also want the indexes, etc. So, I would recommend to script the table, upload that script into another database along with the data the same way you wrote.

The simpler trick, which I sometimes use, is to just rename the original table, then run a script to create it (with all the indexes, constraints etc), do whatever you want with it, then when done, just drop the table and rename the original back.