on 2020 Dec 15 4:48 AM
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?
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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;
User | Count |
---|---|
52 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.