SQL Server - Create Copy of Multiple Tables in Same Database

Question

Hello,

I need to duplicate several tables in a single database. Basically we have an old dot net nuke portal that needs to be split and our host limits us to a single database. So we just want to take the existing tables but copy them with an exact duplicate but different table prefix name (e.g. EEPTL_Users to JBPTL_Users).

I can use 'script to - create' to make the proper table structure but how do I do the proper inserts when I need to specify the primary keys but want the column to be an auto-incrementing identiy?

Is there a tool for doing what I need?

Answer 1

SET IDENTITY_INSERT [table name] ON

INSERTS

SET IDENTITY_INSERT [table name] OFf