Manual Replication

[Jeff Pines]

sp_addarticle generates a .tmp file. The Books On-Line indicates that you
can use this to load data manually into the subscriber, but I can't find out
How. I assume it is some variation on a BCP command. Any clues?

Jeff Pines

[Clint]

Hi Jeff

It is indeed a BCP file.
You can copy it using something similar to this

bcp tempdb.dbo.mytable in c:\mssql\repldata\looA3.tmp /u sa /s /n

You may need to play around with the exact command, but it does work.
The documentation is pretty crappy in this area. It does refer to the
temp files quite a few times, but it only mentions that you use bcp
once. Oh well...

The only thing I can't work out is why in MSjob_commands the command is
always something like

sync -t"mytable" -dC:\MSSQL\REPLDATA\looA3.tmp and not
bcp...

HTH
Regards
Clint.

[Sean Kelly]

In article <353C2241...@vipnet.com.au>, cli...@vipnet.com.au
says...

>
> The only thing I can't work out is why in MSjob_commands the command is
> always something like
>
> sync -t"mytable" -dC:\MSSQL\REPLDATA\looA3.tmp and not
> bcp...

It may have been an attempt at abstracting SQL6.5 from DBLIB (as BCP is a
DBLIB-specific app). It is my understanding that Microsoft is moving
away from DBLIB, though they will continue to support it as it exists
today (I think). Anyway, that is a guess. Perhaps the sync command does
other stuff also...

-Sean