复制定义状态问题
** This Site is 'rszfj' **Status at
Subscription Name Rep. Def. NameReplicate DS.DB A/C RRS PRS
-------------------- --------------- ------------------------------------------------------------- --- -------- -------
sub_clda rep_clda zf02.police 0 Activati Defined
sub_xtcs rep_xtcs zf02.police 0 Activati Defined
我用activate subscription 和validate subscription 说我不是批量复制无法使用此命令
那我怎么把 RRS PRS改成valid呢
它为什么会出现此种情况呢
我在实验环境下都能正常但在业务环境下就不行
以下是脚本
create replication definition rep_xtcs
with primary at sybase.main
with all tables named xtcs
(
sbh varchar(10) ,
smc varchar(40) ,
cmc varchar(40) ,
znjrq varchar(2),
xckqjts varchar(2),
tjkqjts varchar(2),
scys varchar(6),
btys varchar(6),
znjblsdecimal,
cbtcbls decimal ,
tjbl decimal ,
czbl decimal ,
zslx varchar(1),
f1varchar(8),
f2varchar(10) ,
f3varchar(20) ,
f4varchar(20) ,
f5varchar(20) ,
f6varchar(8),
f7varchar(10) ,
f8varchar(20) ,
f9varchar(20) ,
f10 varchar(20) ,
tjsffsvarchar(1),
ccsys varchar(1),
xjfje decimal ,
xzxrq datetime ,
yjfje decimal ,
yzxrq datetime ,
xtnf varchar(4),
jqzdyfs varchar(1),
ybs varchar(2),
jzrq datetime ,
fzrq varchar(2),
cbtctsint,
yhds varchar(1),
cpz varchar(4),
scbzw varchar(1),
printers int
,
tzdprinters int
,
color_car varchar(20),
socketip varchar(20),
gcjffsvarchar(1) ,
getkeyvarchar(1)
)
primary key(sbh)
replicate minimal columns
go
sp_setreptable xtcs,true
create subscription sub_xtcs for rep_xtcs with replicate at zf02.police incrementally
go
check subscription sub_xtcs for rep_xtcs with replicate at zf02.police
go
[ 本帖最后由 maolinzhou 于 2008-3-3 16:46 编辑 ] 原帖由 maolinzhou 于 2008-3-3 16:41 发表
create subscription sub_xtcs for rep_xtcs with replicate at zf02.police incrementally
go...
这句话有问题,你先drop掉那个sub_xtcs然后用create subscription sub_xtcs for rep_xtcs with replicate at zf02.police without materialization
go
试试看 谢谢,我去试一下
页:
[1]