copy whole table at page level by chandra sekhar pathivada

Resolved

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

Type:	Suggestion
ID:	777071
Opened:	1/21/2013 10:40:44 AM
Access Restriction:	Public

Workaround(s)

view

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 (expand)

English

SQL Engine

copying sql server pages.

Improved Reliability

To repair the table
to isolate transactions for reporting purpose
any automations.

0 attachments

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

Microsoft