Link to home
Start Free TrialLog in
Avatar of JB4375
JB4375Flag for United States of America

asked on

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

Avatar of Leo Torres
Leo Torres
Flag of United States of America image

try

Select * into New_table
from  Original_Table
ASKER CERTIFIED SOLUTION
Avatar of Leo Torres
Leo Torres
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi,


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 .

http://msdn.microsoft.com/en-us/library/ms142159.aspx

Note : All the user's logins are should be active ...
Avatar of JB4375

ASKER

Thanks!!