Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Want to change column data type in existing replica table
Message
From
21/06/2000 19:15:33
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Replication
Title:
Want to change column data type in existing replica table
Miscellaneous
Thread ID:
00382949
Message ID:
00382949
Views:
47
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
Map
View

Click here to load this message in the networking platform