How can we improve Cloud SQL?

← Cloud SQL

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

2 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
boniSQL shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • boniSQL commented  ·   ·  Flag as inappropriate

    Is there any other alternative for streaming data changes in Cloud SQL database?

Cloud SQL

Categories

Feedback and Knowledge Base

(thinking…)