Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Want to change column data type in existing replica table
Message
De
21/06/2000 19:15:33
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Réplication
Titre:
Want to change column data type in existing replica table
Divers
Thread ID:
00382949
Message ID:
00382949
Vues:
48
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
Répondre
Fil
Voir

Click here to load this message in the networking platform