[Feature][SQLServer CDC] Support schema evolution for SQLServer

[cyc0601]

Search before asking

• I had searched in the feature and found no similar feature requirement.

Description

Now seatunnel has support mysql oracle schema evolution, does this support SQLServer?

Usage Scenario

my source db and sink db are also sqlserver, when change source db scheme, seatunnel task will stop. if seatunnel support sqlserver schema evolution will be more convenient.

Related issues

#7930

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[cyc0601]

this is my config:
env {
parallelism = 1
job.mode = "STREAMING"
checkpoint.interval = 500
}

source {
SqlServer-CDC {
plugin_output = "customers"
username = "sa"
password = "Pass1234"
startup.mode = "initial"
database-names = ["db_source"]
table-names = ["db_source.dbo.tb_partition"]
base-url = "jdbc:sqlserver://12.16.9.11:1433;databaseName=db_source;encrypt=true;trustServerCertificate=true;"
debezium {
include.schema.changes = true
}
schema-changes.enabled = true
}
}

sink {
Jdbc {
driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
url = "jdbc:sqlserver://12.16.9.11:1433;databaseName=db_dest"
user = sa
password = "11221"
generate_sink_sql = true
database = "db_dest"
table = "dbo.tb_partition"
batch_size = 100
primary_keys = ["id"]
schema_save_mode = "CREATE_SCHEMA_WHEN_NOT_EXIST"
data_save_mode = "APPEND_DATA"
max_retries = 10
max_commit_attempts = 5
multi_table_sink_replica = 2
}
}