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 ...

I'm fairly certain what you want to be using is DTS. It the wizard interface lives under Import/Export data. IMO, It's one of the best tools that has ever been designed for the computer.