|
|
Posted by Lee on 04/23/07 23:23
Brad, Thanks for the reply, my situation is the target table already
have lots of records and I will just append the data to that table.
On Apr 23, 1:58 pm, Brad <Brad.Marsh...@Teksouth.com> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -
Navigation:
[Reply to this message]
|