Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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
2.2k140151180
accept rate: 48%


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.8k49129
accept rate: 31%

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:

×371
×25
×19

question asked: 15 Dec '20, 04:48

question was seen: 803 times

last updated: 15 Dec '20, 09:49