Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sica
Posting Yak Master
143 Posts |
 Posted - 2001-09-20 : 04:47:27
|
| Hi,Which is the best way to transfer 4 milions posts from one db to another?I prefer nonlogging the operation because the log get full everytime I run the stored procedure.I run the insert as a job into a stored procedure.I have truncate on check point enabled.BULK COPY or DTS ?I use SQL SERVER 7.0.Sica |
|
|
|
|
|
nonlogged operation