Could somone tell me why some old functions dont work anymore in SQL17?

I have an existing publication and I want to exclude some table from it.

In the previous versions it worked as:

ALTER PUBLICATION mypub DELETE TABLE mytable

With SQL17 it tells me that such a change should be done within SCHEMA CHANGES, and this keyword leads me to the ALTER SYNCHRONIZATION SUBSCRIPTION statement, but here I can't add or delete any table to an existing publication!!

Any hints please?

asked 15 Dec '20, 04:48

Baron's gravatar image

Baron
1.9k122134159
accept rate: 46%


From the ALTER PUBLICATION documentation:

When altering a MobiLink publication, an article can only be dropped after the execution of a START SYNCHRONIZATION SCHEMA CHANGE statement.

The SYNCHRONIZATION SCHEMA CHANGE is a new feature added in version 12.

permanent link

answered 15 Dec '20, 08:30

Chris%20Keating's gravatar image

Chris Keating
7.0k45116
accept rate: 30%

1

Here's a simple example that shows an ALTER PUBLICATION that adds the data2 column to the admin table on the p1 publication, all wrapped around START/STOP SYNCHRONIZATION SCHEMA CHANGE commands.

start synchronization schema change for tables "Admin" set script version = 'v17.1';

alter table Admin add data2 varchar(64) default NULL;
alter publication p1 alter table Admin ( admin_id, data, data2 );

stop synchronization schema change;
(15 Dec '20, 09:49) Reg Domaratzki
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×370
×25
×19

question asked: 15 Dec '20, 04:48

question was seen: 556 times

last updated: 15 Dec '20, 09:49