What is the fastest way to copy data from one table to another
sql-server-2005
Solution
another option is BCP out (queryout) and then BCP in/BULK INSERT
you can also use the BULK INSERT task in SSIS
Problem
I am having two tables, one is `Staging` and another one is `Report`. All processing happens in `Staging` and upon completion of such process I have to copy all the records to `Report`. The `Staging` table contains millions of records so I just want to know what is the fastest way to copy this data to `Report`. 3 options which I know are: - `Insert into` - `Select into` - creating a package and executing it via a job. Any help in this regard is much appreciated.