Hello, I need to copy a mass amount of tables in SQL Server to the same database (obviously renaming the tables). I need to include constraints, keys, indexes, etc, as well as data. So for example ...

When writing software, you often need to copy database data from production to UAT or from production to development. One way of doing this is to create a database backup (.bak file) and restore it to ...

It seems to do what we want as far as backing up a single table, however I tried copying back the data to a small table I set up to test the bcp command on, and it predictably just copies the data.