copy whole table at page level - by chandra sekhar pathivada

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 777071 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 1/21/2013 10:40:44 AM
Access Restriction Public


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.

chandra sekhar pathivada
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: