Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2014-08-07 : 16:36:22
|
| Publications and Subscriptions.Using Transactional Replication in SQLI thought in the table articles there was a way to allow a change to the source table, I,e add new column, amend column length etc and this flows through to the subscription.Without having to keep deleting the subscription each time.Anyone know if the only way to apply any kind of schema changes to the source tables is to stop replication, and delete subscription first.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-07 : 16:55:25
|
| The default option is to replicate schema changes. If this is not working for you, you have it disabled. Or perhaps you have the option set on the tables to prevent schema changes (had that at my old job, PowerExchange from Informatica adds that option to the articles).Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2014-08-08 : 09:33:06
|
| If I amend any table it gives the message, unable to change schema as being replicated. |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-08-08 : 10:56:18
|
You can remove the object (Article) from the Publication but leave the Publication in place. Now you can modify the table schema. Once done, add the object back into the Publication. You will need to perform a new snapshot.
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
|
|
|
|
|
|
SQL Replication