Hello @galitzel ,
From theory there is no limitation, however there must be some limitation to gain the best performance, include the network, CPU, memory, harddisk performance of the source DB, Replicate server, target DB etc. It depends on hardware , source DB /target DB database types and so on, it's hard to tell in a simple formula.
In general there are few thousands tables are included in a single task. As far as I know, one of our customer has more than 10K+ tables in a single task and all works fine, include Full Load and CDC.
Hope this helps.
Regards,
John.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
