How Do I Copy a SQL Table In Visual Studio 2008

I'm in Visual Studio, Server Explorer, and I've attached to the SQL server. I go to tables and right-click on a specific table, select copy.

From here I want to be able create a copy of the table. I've clicked around a bit, Googled etc. but I haven't found an option to paste or create a new table this way.

Is this possible or am I just missing the mark here? We have some failry complex tables that are already setup the way I need, and we also have a number of tables that need to be moved from an older SQL 2005 server.

I am not that versed in SQL commands, so I was hoping this would be a viable option.

Thanks in advance!!

Who is Participating?
Leo TorresConnect With a Mentor SQL DeveloperCommented:

If you can even use SSIS

Object Source
then Choose
Object Destination

Source can be table, file, xml, excel
same for Destination

You want to do from table in DB to table in an other db Or even same DB

this link may help
Leo TorresSQL DeveloperCommented:

Select * into New_table
from  Original_Table
SThayaTechnical MAnagerCommented:

use the Transfer SQL Server Objects in SSIS . it helps you to transfer all obejcts from one server to another or within the same server .

Note : All the user's logins are should be active ...
JB4375Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.