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

Database Table Copy is a simple Microsoft bcp wrapper to copy all table data from one database to another. Please note that this tool only works with Microsoft SQL Server and Microsoft Azure SQL. I ...

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.