JB4375
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!!
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!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 ...
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 ...
ASKER
Thanks!!
Select * into New_table
from Original_Table