on 05-01-2013 5:35 PM
In the next example, the replication definition is always rejected because i am using a ' numeric 15,0)' column type...
I do not found the good syntax ???
create table TB_Primary (col1 numeric(15,0) primary key, col2 varchar(100))
. . .
create table TB_Replicate (col1 numeric(15,0) primary key, col2 varchar(100))
create replication definition trd_TB_001
with primary at SYBPRIMARY.DB_Primary
with primary table named 'TB_Primary'
with replicate table named 'TB_Replicate'
(col1 numeric(15,0), col2 varchar(100))
primary key col1
replicate all columns
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.