General information
Forum:
Microsoft SQL Server
Title:
Want to change column data type in existing replica table
Hi all,
I have set replication in 3 server. And replication is doing fine right now.
e.g.
Server A
Table name: Ash
Column abc datatype binary NULL
Column def datatype binary NULL
Server B
Table name: Ash
Column abc datatype int NULL
Column def datatype int NULL
Server C
Table name: Ash
Column abc datatype int NULL
Column def datatype int NULL
I want to change a column data type in server A to int the same as other server.
What I will do.
Is I have to stop replication or change the data type.
Or change in the replinfo column in sysobjects for that table and then change in the datatype.
Is this way affect my replication?
Thanks,
...ashish
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only