Copy Table will allow you to create copy of selected table (schema and data) to another database or even to another database server.
rows selection or "identity copy mode" make copy process more flexible.

This handy utility helps database developers, performance tuners and database administrators to create a second copy of a table within seconds. The program has easy to learn and to use wizard interface, built-in and online help.

Here are some key features of "Copy Table for SQL Server":

· Easy to use wizard interface
· Copy none, all or selected (by WHERE clause) rows
· Optional Drop target table
· Create indexes related with target table
· Create primary key related with target table
· Copy or reset Identity values
· Copy text and image data (for Professional version only)
· Support project files
· Command line support (for Professional version only)