Posted by Brad on 04/23/07 20:58

On Apr 23, 2:23 pm, Lee <lee.jenkins...@gmail.com> wrote:
> guys,
>
> I have a project need to move more than 100,000 records from one
> database table to another database table every week. Currently, users
> input date range from web UI, my store procedure will take those date
> ranges to INSERT records to a table in another database, then delete
> the records, but it will take really long time to finish this action
> (up to 1 or 2 hours).
>
> My question is if there is some other way I should do to speed up the
> action, I am thinking about use bcp to copy those records to datafile
> and then use bcp to insert it into SQL Server table. Is this the right
> way to do it or should I consider other solution (then, what is the
> solution.)
>
> Thanks a lot!

Use a Select Into statement and make sure the destination db is set to
a simple recovery model.

[Back to original message]