Home Dashboard Directory Help
Search

copy whole table at page level by chandra sekhar pathivada


Status: 

Resolved
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Suggestion
ID: 777071
Opened: 1/21/2013 10:40:44 AM
Access Restriction: Public
0
Workaround(s)
view

Description

It would be better if SQL Server has a feature to take a copy of a table at page level.
we can use "select * into" or "Insert into" , but it reads all the records and takes lot of time for the tables having million no.of records.



Regards,
chandra sekhar pathivada
Details
Sign in to post a comment.
Posted by Microsoft on 1/30/2013 at 4:27 PM
Hi, thanks for the feedback. Have you tried using the "bulk copy" bcp utility? It provides very similar functionality. In this case, you should be able to bulk copy the data from your table out and then bulk copy back in to another table. More details on using this are available here: http://technet.microsoft.com/en-us/library/ms162802(v=sql.110).aspx
Sign in to post a workaround.