Support CDC for SQL Server databases
I would liek CDC running for several reasons in user databases, but this seems not supported. I did a quick test like below:
CREATE DATABASE dummyDB;
GO
USE dummyDB;
GO
EXEC sys.spcdcenable_db;
Output:
Msg 22902, Level 16, State 1, Procedure sys.spcdcenable_db, Line 20 [Batch Start Line 5]
Caller is not authorized to initiate the requested action. Sysadmin privileges are required.
Also tried to import a database (with cdc on) backup, and the import fails.
This is not included in the list of features not supported, and I think that it should. https://cloud.google.com/sql/docs/sqlserver/features#sqlserver-unavailable

1 comment
-
boniSQL commented
Is there any other alternative for streaming data changes in Cloud SQL database?