After sqlserver starts the CDC function, can the automatically generated table be generated on sqlse

Copper Contributor


Problem Description:

I have two servers (server 1:, server 2: The 2008 version of sqlserver is installed on both servers, but these two databases are not master-slave libraries. Now I want to turn on the table CDC function on server 1. By default, after turning on the table CDC and the library CDC, a schema named CDC will be generated under the current library, and some tables will be generated under the schema, such as captured_ columns,change_ tables,ddl_ history,table_ CT, etc. Please ask, "do I have parameters to configure other server addresses in the SQL of opening the CDC table in Server1, so that the table that I should have automatically generated under Server1 can be generated on server2"? Does sqlserver support this function at present?



0 Replies