知方可补不足~用CDC功能来对数据库变更进行捕捉

2023-02-14,,,,

回到目录

如果我们希望监视一个数据表的变化,在sql2008之前的版本里,在数据库端可能想到的只有触发器,或者在程序端通过监视自己的insert,update,delete来实现相应的功能,这种实现无疑是让我们感到恐惧的,不够灵活的,而当进行sql2008后,这种情况得到了本质的改变,sql2008为我们提供了CDC功能,它可以实时对指定的数据表进行监控,当前它同时对产生SQL的一些负载。

CDC工作流程

CDC功能主要捕获SQLServer指定表的增删改操作,由于任何操作都会写日志(哪怕truncate),所以CDC的捕获来源于日志文件。日志文件 会把更改应用到数据文件中,同时也会标记符合要求的数据标记为需要添加跟踪的项。然后通过一些配套函数,最后写入到数据仓库中。

CDC实现步骤

第一步、对目标库显式启用CDC:

在当前库使用sys.sp_cdc_enable_db。返回0(成功)或1(失败)。注意,无法对系统数据库和分发数据库启用该功能。且执行者需要用sysadmin角色权限。

该存储过程的作用域是整个目标库。包含元数据、DDL触发器、cdc架构和cdc用户。

使用以下代码启用:

USE tableName

Go

EXECUTE sys.sp_cdc_enable_db

GO

当设置好数据库的CDC功能后,我们可以查看一下是否已经设置成功

SELECT  IS_CDC_ENABLED ,
CASE WHEN IS_CDC_ENABLED = 0 THEN 'CDC功能禁用'
ELSE 'CDC功能启用'
END 描述
FROM SYS.DATABASES
WHERE NAME = 'tableName'

同时,数据库的用户将会多了一个CDC用户

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUoAAAFRCAIAAACdWnMKAAAgAElEQVR4nO2de3RV1b3vc0/PGKe9nrbDHtvTa7Eej+2xvVrUVo88gxGxCBGpPBMBBQyPgIC8FFDkEQIhQCIhAUECCYQQE2KU8MagaLRAAgGBoOEhIIGQAAFCQuZjrfvHPt13s1577fWac8/9+4wMxtpzz8dvbeZ3/daac/7WjJJNM0sfdeal86c2nsm9XDn+3PbuNcX//W3BI0dyfv/1iv/YveT+4rn3Fc78dcGMe9ZMvTfrjd8+0OZXei1GRUVFRUUFfvT/q5kYdSeBGRT5NdtSfGvQkOYBAPCGW10zLWnyvGljpo59JWFQ7z49Y55u/9ijf/zPB9r86t9/8VP1n4ZZKn1qCs9AyZrXAs0UdYvqRL3WjesEALZAvwQAYQF5A4CweCHvExV5FZ8u2pn/VsmqscUrx36yZsKnhXMq9qzyoGkAiGRcl3fFp4tqDq2+dGbTzYYd6NZedGvvzYYd578rOPzlsu0bp7vdOgBEMu7Ke/u6SbS13OAv8+2+rhoAAJGM6/JuOpbYcmklurnFp2d0ay9u/Kjp/KKmY4kXtncGeQOAe4Qg75DmvX18smZC45fPNB1LbDq/qLk+t+nM3MYDva9sua9u4/86lxtV88E/6clbc5oq+MlYKmUTJo0CgBlCk3dI6bIsl6waayzvJZNe0LXMkmaYKA3kDfCJu/IuXgnyBgBmuCvvwsyRduStvu/VS1EvcVMkqterqle8KvKrD4K2DgBcEbK81TqxI+/kxG66lumv/Qx6EHQNqVqljhwAAFe4673z0oY7KG/ZcJG5ZobARHXNBm2BvAEBCCd5m9FVSHmstQXyBsIF1+V9zYa8DZ51FXfaiidk/7G6iGa1gfk129KsWdMeAOAHd+e9VyXFGXvvaYM7OXEWRhjflgOAwLjb3VclxV38tOv1b0ZoyvtI1o89kLcM49tApOJ6jy9M67Nn3ctHP3uz9tvMpjNzG7568dSHD3699JdFsx5If/0Jt1sHgEjGC4f2dWly8cqxq5Lilkx6ITmx29KJT+fOfnbnquEeNA0AkQzcrwKAsIC8AUBYeJR30fq0wD9rlQQdMA91pE0vv5l5dcW3enN7eoRkJwD44a7rFK1Pa/jhk9tXt96+urW5oeDm2aWhKtw/O634VzObrLMiXTNdT3LGl5KgWg1a3NRpA4AKL7pOSBPmCtddsHZR/uqF+asXrluZvG5l8trMuf4/40bNe289rTquq6D+X+8q46wZQOTgkbzNpxetT2ttLPP/3b5Riq8U4oY8ciGTnFlITs5AxyY27R/ZVB4/bfwwdXFNN2v+o56uDJRpxr2ra1BXrigF8gbs47W8AzurprzzVy9sbSzz3Zy3NP5D2OdSyckZ6JtxLRXDbn7Rt3F37KH3f60pb38rankE9dLqDObVqy5uXJVeQXUGkDdgGe7kvW5lsl/ed2j72MSWimFN5fGNu2MvFjzxddpdicP6azandob+FHU22YT3NikwM9n0HLumqg0uJQBgBu/krZaQprzXZM5tbSzz+W18aZVa21c2dz6//uE9C+96+aXu6uKaktaTtyJdU/8GItf17Dou2uD6YiYbAIQKd957Tebc21e34iuFPm3j03P8D9s+bdcVPnku+8HSOT/v8UwHvRaDClXhpQ28d1Dd6jUamG58CdC8cAStFgCCwp28Vyx5+/bVrfjSKnIhU6HthtKYusInz69/+GRWm4IZ93T4yyPq4sZCVeQMLKKZrplfEz2hambTK6V57QB5A5bhbuQ8c+G05oYCv7ZbqkY3lcc3lr3o1/aZlfdXp/9yzdR7H/mv+zWr1bvp1cymlqWBV9dz4EGdrdokgyJ6lxsACBWP5C38xuAGKXpaNXkdAXkDluGu64TRxuAG2vN/pajZ4BKjB8gbsAx0HQAQFpA3AAgLyBsAhAXkDQDCwqO8HYn39gHjUkAkw13vtx/vHQjIG4hkuJv3th/vDRPIAOCDu1VrNuO9FYCkgUiGuzXnDsZ7g+sGIhzu5G0/3jsQUDUQyXgnb7UvdSneG9ZvA4AP7ry3I/HegW2BpIGIhTt524z3VjekGVICAJEAdyPn9uO9ZXMBoQAgPNzNe9uM91ZEYmr6cACIELjr9Dbjvf1oBleDyIGIAro7AAgLyBsAhAXkDQDCAvIGAGHhUd42472Djp/ByjYgQuCuKzsS7x04H6bWrfFCF5A3IAzczXvbjPdWiFlTyebFDwBhDXer1pyK91YvblEIWHNlmwzyBgSCuzXnTsV7Bx4YrGBTP2+DvAFh4E7ejsR7ay5N1bwnVxSBoTVAJESL95bv1LZJ760o7shZAwBzuPPeNuO99R6z1YnqUnrfAkCYwp28HYn3VstVbxQNJsYAgeFu5NypeG/FsYF/hqE1QFS4m/d2an9vzYPAZ3IDnP8JAIAF3HVlR+K91R5bVo20GZcFAAGArgwAwgLyBgBhAXkDgLCAvAFAWHiUt4P7ewdFbyANBtgAAeCuE9uP9w510ktv0lux+gUmz4Cwg7t5b0f29w76VVBJGwPyBsIC7lat2Y/31lu7IuvIW1FQnWhQDwDwDHdrzu3He5vx3prZFN+arAcAuIU7eduP9zbjvdXGGKgdvDcQpogZ7y3rKFlPw8b36uqrAMgbCAu489729/cOSd56iTLIGwh/uJO3/Xhv8zfnsmnvDTfnQDjC3ci5/Xhv80Ni5p+9zTcBAPzA3by3/XhvR0bOZcPBc5A3EBZw103tx3vr3WkH3lob6NbYaRuUBQDegJ4KAMIC8gYAYQF5A4CwgLwBQFh4lLcH8d7m57o0Z9ENCsLAG8AP3PVFm/He6tUsmsrUW7KiGF3XHEUHeQPhAnfz3vbjvfUwo1W9b83I239dCNUwAHAJ7latObW/txpNHRp4eFnfySvqCXoDDwBM4G7NuSPx3mZuyNX26FWid14Kdw3eG+AN7uTtVLy3+qMZt2zNe+u1AgBs8U7eaoW4Gu+t/migcz2h6qldXVYvDwAwhDvv7VS8t/qj+uY88EDWkbdmDXr1m7mlBwDP4E7ejsR7G9xLB81s7MnV0gXvDXALdyPn7sV7G9xaa0par4iZagGAB7ib93Zkf29N1HfdMsgbEBru+qIj+3srMHgeVotTLW+9G3jzeQCACdAFAUBYQN4AICwgbwAQFpA3AAgLj/L2cn9vABAY7uRtf39vAAB8cDfv7cj+3k5NTTlSgwVjYF4NcATuVq3ZjPc2WJTCCsUSmlBLAYBluFtzbjPem0NVgLwBVnAnb0fivdXaUCxEDVxqJst3LGtTH6jrUdwjGEtRUUSvfuPFcGbOAgAUeCfvqDuRXYv39qF5l66pE708ssqFatajmTNoKZM1h3oWABAId97bfry3ui3FZUXWUqNaTkE/atZsbIZx65o2G7QF2gaM4U7eNuO9jd2dZrbARAvyVtejlydUeZsvBQCacDdybjPeW8+dBibq+VuDIgaJxt5b0+Xqta6ZxzgdFA4YwN28t3vx3gAQaXB37Xcj3hsAIhPu5A0AgFOAvAFAWEDeACAsIG8AEBYe5e1UvLfxpFHQOW0ACHe469MOxnuDvIEIh7t5b5vx3lHB8GeT5TsWhAUuF3HlVwAAz+Fu1ZpT+3uH5LplleABQAC4W3Nuf39vWcstay7tVKzuhGWegGBwJ2/78d6yvnNWfAxMBFUD4uGdvNUe0r39vYMOm+k9e4PIAZHgznvbjPcO1K3JoTV1OgCIAXfytr+/t6xzK65OAe8NiA13I+f29/eWQ5G3WuchnBgA8A13896OxHuD9wYAmcNVa47EeyuGxE0OpKvTASCsgd4MAMIC8gYAYQF5A4CwgLwBQFh4lLc38d5msgUdgQcAnuGuvzq7v3dQQaoXnxsUd0TeEsZSY6NUWyvV1NCqKlpeTnftoiUlJC8P5+eTvDxaUkJ37aLl5bSqSqqpkWprpcZGCWP7TQORBnfz3t7Ee/szax6rE42vAlJtLT1wgJaV0dJSUlBAsrNJRgZJScEzZ+JJk/Do0WjIENSnD+reHUVHow4d0LPPohdfRPHxOCEBjx+Pp0/H8+aR9HS8YQNJT8fz5uHp0/H48TghAcXHoxdfRM8+izp0QNHRqHt31KcPGjIEjx6NJ03CM2eSlBSSkUGys0lBAS0tpWVldP9+6eJFc/8zgOBwt2rN1f29Q/02cFmbn7t/9CN68CApLCQLFuCEBBQTg3r1IrNm4alT8axZJDWVZGWRnBxSVES3bqWff04rKqTqaunsWamhQWppMf6tDJBaWqSGBunsWXr8OK2ooJ9/TrduJYWFJCeHZGWR1FT8DxvQCy+gZ57BCQlkwQJSWEgPHpSuX7fcLhC+cCdvR+K9fRjccgf9yv+vhLF04sSge+4hS5eW/uEPKDYWPfssHjGCpKSQoiJaVSXdvGlsBhOkGzfooUOkqIikpOARI1DXrig2Fk+YQDIy6Nat0okTcLcfCXAnb5vx3uZvzvW+lc6do3v2zPjNb/C0ad88+ihq3/7An/6E332X5Ob+9ec/l+rqHPpVvEa6dImWl5PcXDxzJho0CLVvjwYMwNOnk9Wr6WefSefPszYQcB4B4719GDxmK7jnn/+ZfPwxTkrCQ4ei6Gj00kt4ypRZbdrQXbv+8OMfm6wkHJFOn6a7dpHly/Hkyehvf0PR0XjoUJyURDZvlq5dY20d4ADceW9H9vc2fq72IV24QPLycELCxb/8BWdk0JISevSo4tk4cGhNb3xOGKSWFnr0KC0pwRkZqFs3PGIE2bBBqq1lbRdgHe7k7VS8d6AOAwUp1dSQDz448Kc/1Tz+eOr993f86U8NpGv+FkA86MGDZMkS9OKLaPBgsnq1dPIka4uAkOFO3o7Ee/vxK5YeOUIyMlCfPigujqxYIZ04EZjHoLjBxwhBqq4my5ejgQNR374kI4N+8w1riwCzcDfv7dT+3j5h0337SErKuT//+cuHHya5udK5c5o5DSoxmTMSkL7/nuTk4KFDUc+eZOFCun8/a4uAIHDXX23Ge/tU3evuu/GsWSgmBo8dSwoLpcuXZf0HaePRdb38nvwYnCLV1ZEPP8SJiSgmBs+eTT//nLVFgDZCdVOybRt+80301FN48mRaWio1NbG2SHCkmzdpaSmeNAm1a4ffeots387aIuAOBJE3WbcOxcTguXNpWZlEKWtzIg6JELp7N54zB3XtSvLyWJsD/A9hL2+yZg3q3Jm8957l1WP/+3eJjv85eorhhHT9OklPR9HRJCeHtS1A2MpbIoSsWoXatyeZmXYWcssgbxeQmptJRgbq0IF88AFrWyKa8JO3dPs2ycpC7dqRlSsVC6etBYrb0TDI2wAJIbJiBW7XjixfLiHE2pxIJJzkLTU1kaVLUadOJDtb/a3lQHEzmgxV4dZOUFTI6tWoQweSkSHdusXalsiCa3n7p8cXTJ9e3r9/U8eO24cMcTxQXFOrescmrwKO/QQCQXJyUJcuJC1NamxkbUukwLu8pfp6kpKCunUj+fmB6erMlgPFLcg7qCd381cJb0heHnr2WZKaKl25wtoW8eFX3lJt7f6+fdHzz5PCQsVXzgaKh3pzLoO8bUMKClD37jg5Wbp0ibUtIsOjvKVbt8iCBahXr5LhwzUzOBsoDt6bFaS4GMXG4pQUm3MfgB7cyZts2oS6dCFbt8peBYrDszdbyJYtKDqalpSwNkRAOJK3VFuLR4wg8+f7U7wJFIebcx7A8+bhUaPC92U4fMKLvMmaNahXL3rwYGCiN4HiTt2cm/TwgB60shLFxsJyNwdhL2/pxAk0YADJzFR/5U2geEjylk1oG+RtB5KRgeLjpe++Y22ICDCWN87KQoMGSadOaX7rTaA4yJs3pJoaFB+P33+ftSFhDzN5S83NKD4eb9zoVIWWA8UNdGsmD8jbJfCGDWjQIOn2bdaGhDFs5E3370fR0VJNDZPWFZhUbEh/rM9JEKQTJ1CnTrSykrUh4QoDeZPsbJzIkQBA3pyDR42C8TZreC1vPGkSycryuFFjrlyqOrJ32c7CKZvXjf9o9ZjiVYmlueM+/zj5fM0XrE0D/geSkYGnTGFtRfjhnbzp2bPor3+le/d61qJJyjfPqj+9iraWB/5dPrM2970E1qYB/x+6Zw96/nkKu6mEgkfyplVVePRoPqMIPitIREf7oYYP0LXC21c23L64rPnbCXWfdlw+4xnWpgF3INXXo1Gj6NGjrA0JG7yQN92/H7/2mgcNWWN37pCWg881nU9trs+5cfz1q9t+eyk/6rsP/sm/DLZy59esbQwn3H6NLB46FAbbTOK6vOkXX3A1kKZmZ/bg1qrYpvOLm+tzblSP88n7sTYPBC50//7ACYMaNN+gHHTPE80UR2q21rqilHqpv9636q80T0Tv7PTOXa+ULMt41Cj61VfGeQDZbXnT3bvxG2+42oR9tq16ubWq1y2fvL994+qOBy/lR0VFRd0bFRXf9jfJgzsOvO++uHY99IpHab0XXf2tpt7Md27zNVtr3bgtzQoDK7Emb4P0oOBx4+iePSYzW2tFgAuHiydAt2zBb73lXv1OseX9gfhwr1s/LGmuz7lRPd4n7z/f9aOFgzuXLxt+fOMba8bE5M8YqFfcpAhlre7iiLwN6jHfuoPy1msrJNmbAU+ZQs29WR3k7TB03z787rsuVe4sJZn90ZEXmn5YHCjvHUkTDmT1q949p3rbjOOlk/++bGTQejTdV0gCU9zx2qxZr5KgNQQqVk+3Iclb83oRWLleW3q/jz9x3e9+1+VnP9OsNtBU9Ue9+jXN08yjVw9XuGIW3bcPTZ3qRs1uUPxeH3SkZ/MPi5vrc25Wj7+248FL+VHR/+dnG6c+V/3x/OrSecdzR+xbGeQRw4zwjAXmbM2htm4yp1rein8NKjS+TBhn0zNDluWi3/+eVlQYGK9Zj5mag+bhWdg+nDdOqqlBcXGOV+seH6a9JFfHosvpzfU5Td9O2H5anrb2eFTUL2YO6ndwxYiytKGz+vw2fXTs5iPNejUE7dma2TRTnKo51NbdlrfahZqpx6QIUf/+0unTiub0jNE8wUAjzbfOubZlN+SNOnRQvH6cc4qyRh4u6X3pWFJzfc6bed89P785aas8NoUc/uxI1doxU15oO3Rc3bQs+f6E24t3XlQXd0Q2mlir2VrrITlbRR6T3ttCPSblLbW0oM6dTZ6d+qNBzcZ5Ik7e+JVX6LFjztbpNjevnCkrmp2TPnz7abnbrLPlF+QD9fKBK/LmzceP5+auHDt51Ap54Hty7yT5j6OuJG+uVxSPuhNFojqbQYp7NTuV4k/0H8taslR8qzBe7+wU9RicuOIgKiqKHjmChw1TVKtptua3egUNPurVwxVOGofnzaMffeRghR6TvLk+Nrn+0DV5+2m54Iic9Y9B2Vfmy7Gz5N5Jclya/PDI40xtBHQhRUUkJYW1FXzhmLxJYWG4/7iT8+TkzfVf18kFh+UVe+VZH8tv5sr11+ShaXLvFLl/qhy3WG6baLS+BWALTk4mxcWsreAIZ+RNT55Er7/uSFUM8cm77LycXS7PL5Un58kD0+Thi+WXF8sDF8txi+XBaXLbRHhJENfg11+nZ86wtoIXnJE3TkigVVWOVMWQ7afl+wbv7vzmyXYTTz4x4eSfx55sm3jyjwln2yaeaJt4vG3iiccSTzyUAFGiXEMrK/GoUayt4AUH5E1LS7HOOw/DAoj3Fgz8zjt02zbWVnCBA/JGnTqF9QuxIN5bMKRbt1CXLqyt4AK78iaLFpGCAkdMYQXEe4sHycsjaWY3eBcYW/L2vbDWKVNYAfHeQoIGDAhcyhaZ2JI3nj1bgBE1+/HeevC/7EFg6KFDeK5yL/dIw3rnk06eRAN1wyTDCJvx3saAvBmC+vWTInuSzHrnIykp6p23wxGb8d7GgLwZQjZuJIsWsbaCJdY7H27XzkE7GOJIvLfecmXjFMBVJIxRhw7B84mLxa4m0vpe+/HeUXeGWJg8ADwg3OMgbGKxq6G4OE62ELKP4/HeMqiaG6QTJ9CgQaytYIaVPkcPHgyLl6iZxGa8twzy5hs0ZQo9dIi1FWyw0udIRoZIez7ZjPf2YfCkHV4RwuJBsrPJ8uWsrWCDla6GX3tNgOluNRDvLSS0shKPDP4mTCEJWd4SIUiUMXMFEO8tJBKl6KmnWFvBhpDlLXDAHcR7i4oYAcsWCFneZPVqUZ9kIN5bVMiyZWTtWtZWMCBkeePXX6dfCxViAfHewkO//BJPmMDaCgaELu+xY2lLixumsALivYWHNjUJ8LIwC4Qmb6m5GUVHu2QKKyDeOxII95eOWCNEedfWol69XDKFFRDvHQmg2Fipro61FV4Toryrq9HgwS6Zwgqn4r39S1Zg7QqHoJdflr79lrUVXhNaL6R//zseO9YlU1jhYLw3LEHlFjxmDN23j7UVXhOivHfswDNmuGQKKxyM9wZ5cwuePp3u3MnaCq8JrReSggKSmuqSKaxwI95bc3k53LQzhCxcSD78kLUVXhNab8P5+XjDBpdMYQXEe0cCeMMGnJ/P2gqvAe/tZLw3yJtbwHsHR8hnbwfjvUHe3ALP3sERcuTc2XjvwLkxePbmBxg5D46Q895+IN5bYGDeOzhCrlrzA/HeAgOr1oIj5JpzPxDvLTCw5twUaOxY2qw7hhzWQLy3qNCbNzFEjJkBjxtHv/rKDVPYAlHfAkO/+AK/YbRyQVRCf1uLoO+dhKhvgRHs3b7msfSuNRHfOwlR3wIj6rt9gxL6m1IFfe+kOuob4r3FQOB3+wbF0nvORXzvpCLq25H9vQEeEPjdvkGxtEuJiO+dVER9W4v3tg8sa3Mcgd/tGxSLe4yhyZMdN4Utiqhvp/b3DhWQt+PgiRPpkSOsrWCD1R1C4+Ol74Ra4KGI+rYc761eea7Io1lEkeLC+UUoUnU1GjKEtRXMsLq/96ZNZP58Z01hiyLq24N4b00Zg7adBScl0ZIS1lYww3pnQu3aSYQ4aApb/FHfinjvs01y640b33+y5ftPtty+elWvuNozqw/UzlkzqszJs4pspNZW1LEjaytYYr0zkdRUUlDgoCls2bjkxcMlvdXx3meb5Jb6huJHn/ikU0xLfYNmWbUmQwrz1rwuAPYhGzaQJUtYW8ES651JOn0aDRjgoClsWbOgr2a896kbcuuNG8WPPrGl6/OtN25oxnsbeGaDR2vNUrKWSwesgfr0kc6eZW0FS2x1IzxnDj10yClTmKMZ7916rfH6qdOfdIrZ0vX5a8eriVbUEbhfDqGVlTgpibUVjLHVF6VTp0Ry4Jrx3kcWLvK57i1dn/+4XacTq7Un/GHQmzdQ377S99+ztoIxdrsjWbyYiPICSs1478OX5YoZszb938eKH33iyMJF165eYW0mEByyfj1JT2dtBXsc8DYoOloSYs9QzXjv2fnyh0fkrye9tW/m7A+PyBDvzT9SUxOKiWFtBRc4IG+6bRueOdN+PWyBeG9hiMyXomrizLMiHjmSVlY6UhUrIN5bDOj+/TgxkbUVvOCMvOmpU3jcOEeqYgXEe4sBGjOGRvyImh/HRnpJcTFOTnaqNu+BeG8BwHPn0o8/Zm0FRzg5kUMWLCBFRQ5W6CWW472j7kQOWJcSpYOioLqewBRZtdBFb/GMZqMGbanTDU5NM0XvK808BmfhCELukGUTh39iPGxYmAbf2Yz3jlKtPDM+0Ozo6jxm5G1cp8m2jM/IvM3WzsI+9NAhnACjJEqcX4YRpi+UthnvrZa3QhKaHxXH5oWhdzXRTNFrSy1a83WaMV7dkPFZWEa6dQt16eJIVYLhvLyl06dR//6OV+s29uO9FR81e3lQeSvyqIWhqUk35C1rCVIvj9psC2dhGdSnj3TunCNVCYYriyhpZSWaMsWNmt3DTry3rKM3gw5t4L01P7ohb1klYONTs+y9TZ6FNdCkSfTgQfv1CIkr8pZlmR44gN9+26XK3cB+vLf6o567lg0lJ2tJQu0bjf2qg/JW26DZkPGZmjkLC+Bp00DbBrglb1mW6fbtOHx8uJ14b1lfvW7I26AG4/rNGGZQymQ9ls8iVPDEiXTXLsvFIwEX5S3LMt2zJ1yWu1iO9466k8AU+U4nqVa4wr0b1+BPD8xvUI9e5Zr1q1FXolePZrt69uudRajgMWPo3r0WCkYU7spblmX61VfhsquJ5XhvwGNwQgLdt4+1FWGA6/KWfYH1Q4d60JBN7MR7hzuajpdP0JAh4u2i4RIe/S/So0fRiBHS5cveNGcNiPfmHOnSJTxihFRdzdqQsMG7izQ9fx716EHLyjxrMVQg3ptn6O7dKDaWXrjA2pBwwut7MDx1KsnI8LhRM0C8N8+Q9HT81lusrQg/GDxikdxcDgfbIN6bW3BCAlm/nrUVYQmbERRaWYk6duTqIQrivTmEHjuG2reHgTTLMBsglVpb0eDBOC+PlQEKIN6bN3BeHn7lFQlj1oaEMYznP/Dy5SgujofdCGF/b36QqqvRgAF41SrWhoQ97Kc3pZoaFB9Pli5lawYn+3sDJD0dDR4snTrF2hARYC9vHyQ3F/XsSQ8cYGUAJ/t7RzJ03z7UvTuMojkIL/KWZVmqq8OjR7PaOMZOvLd6lbXiWJ0HUIDnzMFjxkgNukE7gAW462q0pAR16kQ2b/a4XUf291anqA8ABWTzZtShA/X8fzwS4LHPSbdv49RU1LOnly9mdGN/b4WkwXUrIIWF6PnnyeLFEkKsbRETfnubVFdHFixAzz1HNm70oDmb8d4+1LGTxnkiFrJhA+rWjaSkSPUaGyoDTsF7V5OuXiWLFqGYGLdHXNzY3ztongiE5OaimBiyZInU2MjaFvEJj64m3bxJ0tNRdDRZs8a9VpyN945wGash2dmoUyeydKnU1MTalkghnLqg1NJCMjNR+/Zk1SqJUsfrdyreG1x0IBLGZOVK9NRTZPnycHxDdlgTfr1Qwpi8/ywpzPgAAAmDSURBVL4b3QXivZ3F7csxEJTwk7cfx2/2IN7bKbx5mAKCEsby9kFyc9HTT8NQDSd4NhQKmCHs5e3DN9GC3n2X7toFk6jeI7W20h078OzZnk1kAmYQRN4+vnxn/JlB/Vrbtzs/oPf+aWMt+HOTQ2IwcuZDamykJSV4wgTUsSOeMYPs3MnaIuAOxOmmRevTGn745PbVrbevbm3ektzyVtyt6M549GiycaN08aLJSsy8MFSdJ9LULtXWkvx8PHIk6tYNJyXRL79kbRGgDdf9cpY+6sxF69MC/wrWLspfvXDX3MnHhg5sfObpSz2eOzBySPG8qWsz5+o1Z7B03CBFL1E8pFOnSHY2GjIE9epFFi+mlZWsLQKCwHW/1JSxXnrR+rTWxjL/3+0bpfhKIW7IIxcyyZmFaMdYNKdPa68urS90/vRvPemxY4rioG096NGjZNky1K8fGjCALF9Ojx9nbRFgFq67ZqCMA1WkKe/81QtbG8t8N+ctjf8Q9rlUcnIG+mZcS8Wwm1/0bdwde2xBm619X8CvvIJiY8miRbSiIrAJPULKIwb0wAGSmopiY/Grr5K1a6UzZ1hbBIQM150yJHmvW5nsl/cd2j42saViWFN5fOPu2IsFT3yddlfisP6yLEuXLpGNG/Ho0ahrV/zee2TTpvb/+q/+KXS91eNmjsMUqamJVlWRTZtwejp65hk8ejQpKJDq6ljbBViH607pk7HaSWrKe03m3NbGMp/fxpdWqbV9ZXPn8+sf3rPwrpdf6h5YULp+nZSWkvnz9z788NUnnzz5+OMlDz2UdN99A//t3x75yU/U3jvocbgg1dTQbdvIsmX4jTdQr14oJga/9hqZP59s2SLduMHaOsABuO6UIXnvNZlzb1/diq8U+rSNT89BxyY27R/p13Zd4ZPnsh8snfPzHs900GzO14RUW0v37n3z3nvx22+juDjcrt2htm3x22+TNWvo3r33/8u/hOnNuXThAt27l2Rn4xkzfOeF4uPxO++QtWvpF19ItbWsDQSch+tOGZK8Vyx5+/bVrfjSKnIhU6HthtKYusInz69/+GRWm4IZ93T4yyOazenp9pGf/IRu304yM/HEiScffxzFxODhw3FyMikooJWVfK6Wk65doxUVpKAAJyfj4cPR00+j3r3xpEkkK4vu2CHV1LA2EPCCsJF30PTMhdOaGwr82m6pGt1UHt9Y9qJf22dW3l+d/ss1U+995L/u16zW5E241NREDx8mxcUkNRWPGoW6dUM9e+J33vnooYfwzJkkJYVkZJDsbFJQQEtLaVkZ3bePHj0qnTkjXb4s3bpl7aeQZVm6dUu6fFk6c4YePUr37aNlZbS0lBQUkOxskpFBUlLwzJl40iQycybq0QN164ZHjyapqaS4mB4+DDGYkQnv8jY/7710/tTGM7mXK8ef2969pvi/vy145EjO779e8R+7l9xfPPe+wpm/Lphxz5qp92a98dsH2vxKsznLz9hSXR2tqIi9+266bRspKiI5OSQri6Sm4lmz8NSpeMwY/OqrqF8/1KMH6tIFtWuHunZFvXqhuDj82mt4/Hg8fTqeN4+kp+MNG0h6Op43D0+fjsePx6+9huLiUK9eqGtX1K4d6tIF9eiB+vXDr76Kx4zBU6fi2bPJokUkK4vk5JCiIrptG927l1ZWcr4TK+AZXMs7JNKSJs+bNmbq2FcSBvXu0zPm6faPPfrH/3ygza/+/Rc/Vf+pi+s9PKufq23OjUmESNevS7W1Uk0Nraqi5eV01y5aUkLy8nB+PsnLoyUldNcuWl5Oq6qkmhqptla6fl0ixMJvAkQ44sgbAAAFIG8AEBaQNwAIC8gbAIRFKHkrgsYs1GBmeCzcF6sBkYM4vfOOeO+Ggptnl4akcM1hcM1RcZA3EC5w3Tvtx3vnr164bmXyupXJazPn+v8MWvTL1S9vRboiMbzWpQKRBtc90sF4b194iW+Z6rTxw/RaNJa32rdrlgUATuC6R7oR733o/V/ryVvtog28t/orkDfAG1z3SFfjvRUobrkDj9UpegWtnyoAuADXPdKbeG9N9LSqVnvQIgDACq57pJfx3upxMvVlxfi2HOQN8AbXPdLjeO/AhgwUq3frDvIGeIPrHulxvLdsbsBMLwXkDfAG1z3Sy3hvxZiZ4tjMMzbIG+ANcXqkzXhvBQZa1fTeoG2AQ6BTAoCwgLwBQFhA3gAgLCBvABAWoeRtP97bh4WJLoP5s6D1wFA84BLidCCb8d6B2JG3YtWqZj1mVsipC2rmAQADuO4lXsZ7ay5BDZoSWFzvo2Y9egVlrSuFmVIAoIbrXuJ9vLcPM97bWPAGHthkcwayD2obAPjgupd4HO+taMuMvNUfDW6z1fpUXwX03L5ezQBgANe9xMt4b9lQTmobzN+cqz/Kd8o76FUgaOsAoAnXvYRVvLeB9w7J68qGMlZkVhTRzKl5DAB6cN1LPN7fW9GWGXnrpQT6f9lQ2AY2wM05YBOue4mX8d7m5aSQlqaAjT+qm9b7BcB7A3bgupd4H+/tIyTvHZiuly3ozbyZekDeQKhw3Us83t/bT1B5q78N6aMciryDXhEAQA9xeomD8d5mXHSg6tQPw0GfsaP00azHuDkA0AR6CQAIC8gbAIQF5A0AwgLyBgBhEUreduK9Qx2sgnFsgH/E6Zf24701V7PojVQHnfoCAOZw3Sm9399bgfkJLVvnCQDuwHW/ZBXv7cdAt3BzDvAP1/3Sy3hvM3fgel+BvAE+4bpfeh/vrXdgkNk4GwAwhOt+6XG8t8EKUONRN3gCB/iE6x7pcby3Ze8dNDMAMIHrHunx/t6BLlrdqGZm4xQAYAvXPdLjeO/Am3B/ip5tIG+Af7jukR7He9sZWgNtAxwiTqd0Kt7b5LAZ6BngH+ijACAsIG8AEBaQNwAIC8gbAIRFKHk7tb+3AoNxtaADbHoZYGQO8ABxOpmD+3srUK9RVX8VmGJm4aqiICxuBdyA657Edn/vwK/0PqpLBRW/umDQUgBgDa57EvP9vTUFb+CBDaoyzgnyBtyA657Edn9v9UeD22y1PtVXAT23r1czANiE657kZby3gf8M6aN8p7yDXgWCtg4AluG6JzGJ9zbpdWVDGSsyB33GBnkDbsB1T2IS721wmy3fGVUWVNh656Upe7g5BxyH657kcby3rPKcxjfYBvLWq1DvK/DegBtw3ZO8j/eWtdRlRvOaBwbHinpA3oAbcN2TmMd7W/gohyLvoFcEALDD/wPW/lOvr5H5nAAAAABJRU5ErkJggg==" alt="" />

第二步、对目标表启用CDC

使用db_owner角色的成员执行sys.sp_cdc_enable_table为每个需要跟踪的表创建捕获实例。然后通过sys.tables目录视图中的is_tracked_by_cdc列来判断是否创建成功。

默认情况下会对表的全部列做捕获。如果只需要对某些列做捕获,可以使用@captured_column_list参数指定这些列。

如果要把更改表放到文件组里的话,最好创建单独的文件组(最起码与源表独立)。

EXEC sys.sp_cdc_enable_table @source_schema = 'DBO',
@source_name = 'WebManageUsers', @role_name = NULL

注意,source_schema说的是数据库架构者,如dbo,cdc等

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAToAAAEnCAIAAAC2aBhOAAAYiUlEQVR4nO2de3AVVZ7H8//U1lZtzc5OTbk7O7u1u7WlVW7t6kB4jCLIQxwWhCxOhDA8MyIawiBKcFAmPOSZFJEQiESNQIxBBAmvgIElMBg2CAghPEIIBsEEko3ySHLO6dP7R9ZMuN19bt++j+5f9/dTt271Pfc8c35fTnff86WT9B946623eo6TkpJM03soWPNGZ9se/m2h+GYdb/gjq51z90T63WOp7QefvV0+qLns8abND9fnP1S64Mf9/uMRY3FjK8aPPSk96Um9sKoTAB8TRpZW6etWzL9/u7RHqx2nX7x7LLW98j97tHp148/rcv/6vXk/e+Sff27Ztm25GnVrZ2wA+IwH5GqFsdjaZfParxa3nMz4et/wy9t/ebH0ka8++KfjBX9/cM3Pt2f/bdnCn5Yu+PF7836Wn/l3v3joJ5ZtY3UFIBIcxn3O4rlL5r80b9ak6RNGjx056Mnkf3v0X//hFw/95G/+6i+ML8u2e6nOVIRWeoZcQTBB3ANABsgVADJArgCQAXIFgAzO5bptc07vl/Me2LtvpMgW9g4zAP7AYWRv25xz+/pnnW17Otv23L9deufa2rgqNuQXHXVxyBX4FYe/u4YsraXvryrZtKJk04oPNy79cOPS99dl97zMWw1HSGbTY2OiWtUAUMfhrqZtm3O62it7Xp3fl/PWMn57i/hmnbi6QtQv6NmWOD9jikmrSgVG+m3vbU/YSgF8jEO5lmxa0dVe2X0y3NH+g1C/XinqF7Czr3TUTLlTNa794LOnNvzUVK4P9MD6FDfsV6abEyFU4FccyvXDjUt75PqAVmvndNRM6d7rf7P0seM5P5o55b9MWrV9Mhz2W91CtAD4j1C5GoVhKtf31mV3tVd2r6v820KjVlt3DWza/PChFT964bnhquZt3yVSXLXarwQA0jhcXd9bl93Ztoe3lnVrNcRD17prYHPZ418X/WP5H//ymaf6WbYdbpNwpF/h2hX4G4dyjZXftbeuTNUb9mzZWBBCBX7FTb/rnzthYzG0v/BCrsCvuOl31R8Uqlq0kCsA7vhdFZeXVheiivPhnhtO6nNmAKiDgAaADJArAGSAXAEgA+QKABlckGusjLI2wQ0n4BsSHcrRG2Vt7p0IKRJ1xwFwnxjEcSKNsrq1vc7462ukqgbA48RGrvbTozTK6pHINWxxAGgRY7n2FkOcjLI2l03IFfiPRMs1SqOsjtUVBJiYydW40MXJKItrVxBYEr26Rm+UxckwCCyJlmv0RtkoT4YBoEui7wxHb5S1I1doFfiSRP/uGr1RFnIFgSXRYR29UdY0sfe1K7QK/AoiGwAyQK4AkAFyBYAMkCsAZCDpd7V5Mwn3nIDPoOd31c02NtnJA/UC6tD2u9pPsUoEgBDE/K7QKggy/vS72rQBAEALf/pdsTkR+BKSflc7q2vYYwDIQdLvaucYJ8PAf5D0u0a0ugLgGwLnd4WSAV0C53eFXAFd/OB31X84Qzam4PIV+AnELgBkgFwBIAMZuZ47/UXMX26PCYDIgFwBIAMZv2tvmSUlJYWVYu88VvnjOkwAYg4Zv2uP8EIISYRcgY8h43c1XTl75KqQqKnCIVdAETJ+V/tyNa69VifJ0Y8dgESSaLk69rsqznIVq6vxK8gV0CXRcnXsdzU9xTWe7hq/hVyBbyDjdw17+zckPUS9OBkGPiDRq6tjv6vVfSPjbST1aTDkCuiSaLk69ruarqumN5MUd4YhV0AaMn5X9YWoUbFWKZAroAsZv6vpPaSQY6uvrGQc/dgBSCRk/K4R3WqyWl1DEhM8dgCiBFv8ASAD5AoAGcjIFQBATK6fHbkQ8tpeea50/6nNu6pP1l5zu3cAxBd6ctWlML4KSw4MHjbpzJEa2dCg1dZqNTVaVZVWUaHt2CE++kgUFYmiIvHRR9qOHVpFhVZVpdXUaLW1sqFB3rwp29s1xtweGQDhISbXTw/V6lJo99q1c6fE7k/5O6vZ3Aw2bsy10Sn3Bz11PXnA92PG8kmT+Isv8sxMnpXFFy8Wq1aJ/HyRny9WreKLF/OsLJ6ZyV98kU+axMaPZ7/+NRsyhE2fzlJS+Lx5Yv16be9eWVcnOzvdHisAoZCRq1Zby4uKmiZOY6NHs4EDr49KPTnxtU/T85a/vCMtoyaveO/jI6Z2vyKtufsHHnn1qlZZKYqK+MKFbOJENmAAGzOGZ2by99/Xzp+Px4gAiBSvy1VeuCDWrmXDhvFJk/imTYdy3pNN1yRvz9zYIqWUUl6sv9In8xrvvHSzoajpYqEDueoW/32xbGrSqqr4u++ytDQ2fDh/5x156VLUAwLAOd6Vq9bUxGfOZBMmiIoK2dranfjhZ1/oUkjR+tuclpGLWvrP/ab/3G8envQF7zjPOr5qrC14bLj5U2HVmMq1N7K1VVRUsNRUPmuWdvOmgyYAiB6PylVeudI1dqx24kRIerdcBW++f+/rW7cu/vuzrzY1nWpvO806vuq6f6r+9Dq1XHv7++yn9EarrmajR8uGhigGB4BDvChX2dzMJkww/apoe5Uuhej6Zv6y9b1fXfe/7Lp34lLNWoVcexQY0YEpfOJEeetWJGMCIAZ4Ua68pIRv3Wr61cbSSl0K0Xnt0cETeMcF1lHbdf/Mo4MndN070XX3+PnqHDtyNabYVKmdHgIQP7woV9nSwidONP0qf0vFvtNyVdntl/Jbhv/hemtb7cqPWxYWt6S83TLs9Qtnj65KjFzZhAny9m07OQGIIV6Uq67rsqGBPfecdvx4SHpe8d7SP/3/DeEpq+raWk933yK+WH9l2OsXTh1e7vjatbdiVdeux451jRwpGxujGx8ATvCoXHVd127c4C+/zH7zG7Fvn2xp6U7MK9674YA+Lffbp7Ou/suEPzW31Pw2p2XM4htDs64+POlEzcGlzu4Mh0U2N4u9e9n48TwjQ/uhMwAkGO/KtRt5+TLPz2fPPMMmTOCFhbveWiMbG9j9M133Tnbdq+68c7Tjzn93fP/5/e/33/9uT/W+xTGUq2xs1A4f5gUF7IUX2MiRPD9fXrkSq8oBcIDX5dqDvHCBFxdfGp/Gxo5l/ZLvjRv+3azxLdnTmwrmXNz2hy8PvX2iYvHxPYscy1XW12sHDojCQp6VxVJTWXIyGzeOz53Li4vlxYuxHQsAziAj127yivc+NnzKL4dNfn5I6utPjS144tn9A56+mPyrE/2e/N8+yTeS+9cnD2RpaTw9nc+ezbOyeHb2A3uGs7N5VhafPZunp7O0NDZuHBs5kg0axKZNY88/z+fPFxs3ahUV8vJlybnbYwUgFGJyVSDv3JHNzbKxUdbVaSdPakePagcOaDt3PuDI2blTO3BAO3pUO3lS1tXJxkbZ3Czv3HG77wDYgphc4XcFQYaeXE39ru+WHX58xFQoFvgbYnLt9rtKrVOKe1J8r/FWwVsEu7lu8/6KY+egWOBviMm17MAZXQqp3e3ezPRSfkvK2y2Ds76173ft2QKh2AvhNcJ2lcpAQJQQm+aSPTW6FFH6XSPdcugFCHUVxA9iQRATvyvkCohCLAhi63dVbw8OKaWoR5FizGBsXVEqpGY7RUzzAH9AbEbj7Xd1ViqiA2PN9tsyvptWRfH0AdiB2HTGxO8akVx1szXZqmZjETsrp522IFegk5NrTPyusVpdjXkUKXYyY3UFaohNZ6z8riGXgupGjUul1cqpSFFUYlrKNJupXBV9szM6QAhic+mW3xUAL0BPrroUcfK7JhmIYc8BiB5iEdkt1+bG969fKmw8V1B/6p0LJ3LPHl0Vvd8VAO9DT66PDZ+ifrndRwDiBTG5AhBkiMkVflcQZOjJFX5XEFiIyRV+VxBkiMk1wX5XZz/n4EcgECeIRVXi/a7OhOdBuXqwSyBSiE1h4v2ukCvwDsSmMPF+V9M8Vikh/xCYbvc1fmVVs/08xi6ZfnRQD/AUxCaGlt81RDDxOzDq0DiusHkgVO9DbHoS73e1Cn3jWhpSyri+xeogbOvqDoRtAngWYjPkKb+rWq7xPjC2pWjdmA1ypQixGUq839U0j+kSZ1qtaR5F68YlUdG6YgjGHlpVrmgIeA1i0+Mnv6sdbUA/oDfEosE3flfHCzsIMsRCAX5XEGToyRV+VxBYiMkVgCBDTK7wu4IgQ0+u8LuCwEJMrvC7giBDTK5uPd/V3R9U8HMO6IZYELj4fNewv5Har8oBkCvQycnVxee7Qq7AdYgFgYvPdw27+TbJevev1Rm4upSd1p2d2wOiEJtgb/pdjTWYZraTx9kBhBoQiE2zN/2upjUYV3KrDIqarcSprhn4FWIz7U2/q7EGO00oUiLqKuQaHIjNtNee72pcGE1LWTWkWF3Vy2mkQwD+gNg0+8nvCkCk0JOrP/yuADiAWETC7wqCDD25wu8KAgsxuQIQZIjJFX5XEGToyRV+VxBYiMkVflcQZIjJ1fd+V/x6BBQQC44A+l0hYNADsVAIoN8VcgU9EAsFun5X47vxnNyqEnXNDs7tAVGITTBRv6vxXbcQWNgU025AqAGB2DST9ruGLWJVj2m1djoPfAaxmabud42JXMMWAX6F2EwT9bvqFmfCViunaQdMs9kcAvAHxKYZflcQZOjJFX5XEFiIRST8riDI0JMr/K4gsBCTKwBBhphc4XcFQYaeXOF3BYGFmFzhdwVBhphcveN3dbZRIWxO/HoEFBALDk/5XZPC7Si0WQ8ANiEWOp7yu0KuIMEQCx1P+V3VclVvCTbdO2XVChQOuiEWB0T9rsYD47vNekCQIRYEXvC72pGrbraS9z6AXIEDiAUBdb+rDrmCKCAWBB70u4Zgv5QezgRr7GrkfzDgK4hFAPyuIMjQkyv8riCwEItI+F1BkKEnV/hdQWAhJlcAggwxucLvCoIMPbnC7woCCzG5wu8KggwxuXrH7+oMd38fwq9T1CE2eZ7yuzpDXU+85QS5kobY5HnK7+oMyBU4htjkecrvGvJt2L2+6nqs+mOswaqgVSn7ozAtCLwDsYnxpt81VgfGnphmtpPH2QGE6nGITY9H/K7G5dT0wFSH6uXU2BOrtowZFDVHNArgWYjNkKf8roo8utn5qp0K7a+cVkVstmWnHuA1iM2Q1/yupsc9eezXo9a5EauaI2rLwZ8CuAux6SHkd0Xog5hDLKRI+F2xTIE4QSyq4HcFQYaeXOF3BYGFmFwBCDLE5Aq/Kwgy9OQKvysILMTkCr8rCDLE5Aq/q/2GEtAKSDDEJhV+1zi1C0hAbArhd41Tu4AExKYQflfju1VD6iFYFUnY6TpwALGJCbjf1fiuWwgsbIppNyBUj0NseuB3tVPEqh7Tau38EYBHIDZD8Lsq/iEwLRi2ZnU9wFMQm6GA+111g1xNh2A1Lqua7f8pgLsQmx74XUGQIRZS8LuCIEMsquB3BUGGnlzhdwWBhZhcAQgyxOQKvysIMvTkCr8rCCzE5Aq/KwgyxOTqlt8VAC9ALF5d9LsC4DrE4tVFvysArkMsXl30u/YcG98VG3dDjnEGDqKBWOi47ne12mdv5wBCBVFCLIA85Xe1kwcn3iCGEIsh7/hdw8rVqh4AHEMshlz0u/b+qFsstlYXxjYbAkANsQAi5HcFIObQk6v3/a4AxAliEQm/Kwgy9OQKvysILMTkCkCQISZX+F1BkKEnV/hdQWAhJlf4XUGQISZXn/ldY9iBsMNxfbAgeohNoe/9rtF0yYPDAbGF2AT73u8KuQIFxCY48X5X001OxlKmO4cVB2ErsarTZuvqDpvmAd6H2Gy56HeNqB7TA0VVVikO2jK+26wZeB9iU5V4v6tuY2mKSNKm2axSjKrr3QHTJiBXH0NsqhLvd1UUN35lpy2bBXunmKoOcg0gxKYq8X5X08u8iFJMa1C0bqVPRZeMrYTI1Sq/sTngZYjNUwD9rtAS6IFYKATK7+qFPgBPQSwa4HcFQYaeXJ35XSXnsrVVNjZqZ89qx46Jykpt925t507xySeitFRs2SKKi0VRES8pEUVForhYbNkiSkvFJ59oO3dqu3drhw5px45pZ8/Ka9dkW5vkPMEDB0AnJ1c1WmurrKvTKitFSYnIzeWvvcbS09moUWzQIJaczIYNY+PG8cmTeUaGyMnhb77Js7PFsmVi5UqRkyPy8sT69XzrVrF+vcjLEzk5YuVKsWwZz87mb77Jc3N5RgafPJmNHcuGDmXJyWzQIDZqFJ8xg7/+usjNFSUl2qFDsq5Oa2tz+88AfAsxuYaYXQ+VHjixamNtZlbT+Ikdg4ewlBSWlsbnzROrV4stW7TPP9fOnZM3bsi7d2PeE3n3rrxxQzt3Tjt4UGzZIlav5q++ytLSulJS2NChfNYskZur7dkjL1+OedMgsNCTq1ZzQhSsZ7MzWJ8+LDWVv7lQfFhcvrJwyLA0j7jnZFubVl0tNm/mCxey1FTWty+fPVts2KB9+aXbXQO0oSFXqWli506emdnVrx9PT+eFBeL0/2isnYTfVQqhffWVKCzkM2awAQP4nDnis8/c7hQgidflKuvq+NKlrE8fsWGDVlW1rdtAR9bvKjs7tSNHeEEB79tXvP22vHgxwR0ApPG0XHl2Nps4UWzf3pPiJ7+r2LaNvfCCWLLExT4AWnhUrrKzk40eLcrLQ9L953cVu3ax556TXV1udwQQwP14NYVNnarV1hrTE+B3TfxJsnb6NJ8+PZEtAqJ4Ua5aVRXPzDT9Kt5+V7cWXj57tnb0aCJbBBQhJtd4+10hV+BlvChXXdf5jBnamTPG9Hj7XV2Rq3byJEtPT1hzgC4elavs6mJjxxp/n0yA3zXB167i009ZSopkLGEtArp4VK7diGXLWGqqKCuTQnSn+MbvKjkXpaXs+ef5smVu9wWQwdNy1XVdXr4sli9nffvy9eu1w4fzN+2Mn981Ach797RDh/i6dSw5WaxcKevr3e4RoITX5dqDKC/nc+fe7z+AT5v23YqZN3ZlXz29joTfVXZ1iVOnREEBnzqVPfEEf/VVsXu3250CJCEj127yivdOHjw+/4lnP+8/uKNPn0v9frV74NDcJ0e99FTK0KcneuT5rvLWLe3YMfHBB3zBAjZ+POvfn82ZI9591/TmGQD2ISbXEGRDg7Zvn8jL46+8wkaM6BozhqWm8t//XqxYIYqLtYoKceaMbGqS7e2xb7q9XTY1iTNntP37RXGxWLGCz5nDUlPZuHFsxAiekSHy8rT9+2VDQ8ybBoGFmFzVz3fV2tvlpUvakSPi449FXh7PyuIzZ7IxY9iQIbxvXzZkCBszhqWl8Vmz+Jo1/I03+KJFfMkSsXy5WL1arF0r8vP51q0iP1+sXStWrxbLl/MlS/iiRfyNN8SaNXzWLJaWxkaPZoMH/7m23/2OL1gg8vLExx9rR47IS5e0775z+48EfAs9uTp+vmv3eqidP69VV2uHD2v79mnl5dqOHaKsTJSUhP7nLyUloqxM27FDKy/X9u3TDh/Wqqu18+fl9esSggQuQUyueL4rCDLE5Br9810BoAsxucbE7xo9XnDegQBCLOxi4neNHsgVuAKxsIuV31XxkBjTj2FdsgAkAGIxl3i/q6ksoVXgCsTCLhq/q27v4YvGxdPUtROzIQFgG2JhFxO/qzHFjs3VVOcAJBJiYReN31WxciouTU1L6WZLLgDxhljAReN3xfIIqEMsaqN8vitu6gLSEAtcPN8VBBl6cnX2fFcAfAAxuQIQZIjJVe13dbt3AMQXenJ17HcFgDrE5Aq/KwgyxOTq2O+q2NmfZEFIQWM9vVN0w8YJq80Ypo0q2jKmK4ZmmmL1lWkexSiA6xCbjCj9rkmGnUnqA9PANeaxI1d1nTbbUo/Ifp+djQK4DrHJiNLvapRrSIibfgw5th/oVv86mKZYtWUUof067XTe2JB6FMBFiM1E9H7XkI+mURtWriF5jIFuqrF4yFU3E5hVHmO3HYwCuAixmYjG76pb6EcRoIrV1fRjPOSqGwSpHprj1dXmKICLEJuJ6P2uxo9Wy6mulJBuFuLGtUu97sVQrsY+mDakHqmdUQAXITYN0fhddWs1xkOuihrU9dvpmKKUzXocjwK4CLFpcOx3TXqQ3in6g4uYUbEhy6+6hp703vkV9VhVblq/elzqPpu2a9V/q1EAdyE2B755visADqAnV9LPd40S04URBAdi8w2/Kwgy9OQKvysILMTkCkCQISZX+F1BkKEnV/hdQWAhJlf4XUGQISZXPN8VBBlicvXI810BcAVicvXI810BcAWScnXmdzXukg05NuYBwFMQC8qYPN/VmGI8AMCDEIvOeDzfNUSiWFqBZyEWl1H6Xbsxes3UeQDwCMSCMh7Pdw2bBwCPQCwoY+53hSwBIYgFawz9rlhCATmIxSv8riDI0JMr/K4gsBCTKwBB5v8ATOjFFlN0ZQ0AAAAASUVORK5CYII=" alt="" />

@source_name说的就是数据表名,@role_name是角色名,为null表示对角色没有特别限制

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAARoAAADDCAIAAADSl0m+AAAOqklEQVR4nO2df2xVZxnHr/5lshgTs81lYSIumpiRqJFNN93cphiiI1uEmMBmSLooWqtjMKsMNBuFmpWOLrgitGBZAaE/LMiPrswWkMFA1gUZY7K12tBLSykFqrT0x71y/OPq3el53/c57znnveec5/b7yU1z7nvf932e55z3e59zzzlPmrC0qVj5zKqlPykuWvCDJx6b852HHrz3C5//3KenTbn1Ex//qPgShycSiUQikd3O/rW3ZLs5eqpGiX1UFsVGlXV6TgAIsGgAMAbkBIAxfMrpbPu29rby17b/cld1UVNV0e6aRW0NK9oPVpt1DgBe+JFTe1t5x8lNfV1/vDawf3z48Pjw4WsD+5Pv15068nLLjmeNuwgAFzzLqWXLkv+MHSVelcvn5sJRAOKPHzkNnSkc6asav7Yvo5/x4cOpwZ1DyfKhM4U9LfdDTmDSknhOgWrA7ppFg0ceHjpTOJQsv36pdqirZPDNxy7vu+Pijg911yY6Nn5YJSfpZWt3/3yNCkgkRkEeIF80hJx2VRfRclqzZLbSmK81GsnKhpyADzzLqakKcgJAjmc5NVQuDCIn8TxK1SI+QuFodCBOJfYXN1ytA6CPc2FlllEQOZUWzlQaUz/L47rh+kyQqAojGwDo4zk7bat40qCcLPIhPWkHe6M4M2ELcgK5JmI56axjT3382YKcgBH8yOlqADkRv1UcZ26OXzjZbXGIdFp7f6kt6cxSfwDQxPN9p+qV8+jstPT7X8u50+RpHgBR4XktVq+cd6HtG/86/UOpnN5e95EQ5GTh+huIJX6WY0PFnINbHn/n0C9636sc6ioZeOPRf9TfeWztLY3PTXvppzOMuwgAF3x+ux/bW9pUVVS9ct6aJbNLC2euXfxg7fPffK36SbPOAcALnCwBYAzICQBjhCSnxq0V9pe/SVwv6Hm9MqHqr3Nfy/Gp6lq/Ck9+Ai6EcVwbt1YMnN89eqV59Erz9YG6a+fWelVU9u6Q46+0m6V4ok/arlritHRdteE6XCtswA2fx1V1t0p6w8qRmuo2l2/fVLZ9U9mWqtItVaWbK0uyLxdftbOTShvG17FrflOp2qwbICb4l5N+e+PWirHBA9nX6L/3pi43pAa2pXsq011l6c5l42cWD51YOHR0/tKnCiQuytKI/lvVOiaUoJO+xBnEyR2jIKe8x4Cc7ItDKqftm8rGBg9kTvZGBv8vpO7V6c5l46d/NtJecO31uYOtj5zccJtUTlkr4nJ0zUJiB321iMPpqVQDxQ6QU74Shpy2VJVm5TRBS2cWj7QXDB2dP9j6yIW6Gccqbios+J7cS9mTdRYpJzo7aS5onW6qxCVVESFdkAcEkpO4ZKVyqqksGRs8kMlLqb5qUUuX99yf3HrXwbKbHv/uLImLMgmp5ORol+qNEJUycylSEKFnnW4gzwgjO9VUloxeaU5dbshoKfXPFdkfSxktXWy4u/v3d+5d8bFvP3yf0lE3YTiyEJGdXHWiMmpvpyUnFarrtIA7Ychp/Zrlo1eaU33V6Z5Kh5YG9j50seHu5Na7OtdNqVt2831fmi5xkRSGo6d9iLRd2l+KShjSbqpRUq1CTvlKGFf2KsuWXh+oy2pp5G8/Hjo6f/DAo1ktdVVN/ftLt9QU3z79s1PlXupdmrMvZZWc6KwinVy6+kWXiCEqeYM8w7+c9O87rf1N8WBXbf9bT3W3zOpouue9uulvv/KZY+s/1bpmalPJHQ2/vq1u2c01xbeve/qT06bcqnRUtiKJzEDkNEd/qS26RaUNTd1CTvlKGMeV0T+GItZ69iPHzISkVUBO+QqOKwDGgJwAMAbkBIAxICcAjBGSnIzUO2XA73gQW8JYmsHrnexATiC2hHHfKXi9E27gABaE8VREwHonp8eQEIgrYcjJYL0TUhOIM2HIKXi90wSPoSIQVwLJScwVOap3wvNvgAVhZCcj9U7/c1evaAKASAhDTgHrnT7wVa9MA4Co4FHvZOkVaAAQLQzqnRyVEdIcBUAcYFDv9IGvsuIiiArEB6xFAIwBOQFgDMgJAGNATgAYI+5yMlgoZU18wMLRTrwVJwnoBshXYr0yjPxjKJ3HkcSPPHUGIEPYKyOSfwxlactD9UAgnhgEOkQgJ/12U4VSxLmcjweXICGgIko52ddlmIVS0k9Fr1Q9kZqAiljLyXihlEoAhISIzgA4iEZO4nd8LgqlskiTkmpb9I344YQcBezEOjsFL5RylYGoimy7JUtEqnYArJjLyVShlGhOfOtop0/zVMkNTHJifWXPVKGUasPeR5qdVH2IbmAyE+v7TsH/MRTxGym7oWq3/5WeAUJLwEGsF0Twfwxl33Y92RM7+GgBkxksBQCMATkBYAzICQBjQE4AGIOBnF5svLS6vn91ff8LO/qfr71YvLGv8OULC8p756zqmbX8/NeLkw/8PBm1jwBYFhc51b5ubTp4Y/2f02ubU6t3jZc0jC37w+gzm4eLqoYX/m74gUWno/YRAMuK+X2nDC82Xiqv73+hrv9XtRcXbegrqOidu6rnW88mv7ok+eWnu7+yOHnPj96ijToeKfLqM/3YkcOEowVX0icVsX4qIsP25vb0jbTjNTKeujqc6r063tk3du/sha52g9x71ZGT9KOc3vA1NSfUbpBYP7OXISOnQyc6Mq/0jfT+I2f3HXp3Z+vp3qvje1pPQE5xmAdYjOSkSk31r/6VlpP4wLiPhxt0Rol9pHKSOkPMLD1TVQXlOo+Oz9KpgA7RyCkxEUsvO7Udf3//kbMj46mdrafrW05t23Py1LmR2t3HCTmJC1pnQzUPLZWcboi+ic44nNSMVFSgJH6gB7PsZM9Lp86NHO+4vrEpMjmJKUJnw3WUvRvhmI6cNG2JM0NU/mAgp1d2veH4vbRtz8mane3VDSeOd1xfX38s2uzkz1bAUVJnVNmJsKWanGgHBFHKSafdsqwNO9rSN9Lney90dl94p7P3zXd7/nLyfMuJ5J+OJhsPd9NysoQvaccXtr2P/a04idgufvdL33oaJY6VdnC4LZWTY3JxWxo+bRHQRCAnr/edflv76hdnLpgxq0D10rmyF1uwavMJHMsoQR7IM3AgATAG5ASAMSAnAIwBOQFgDAZyQr0T4AIPOaHeCbCAwX0n1vVOvo169TA0W4CAwVMRTOudIKdJCINn9pjWO0FOkxA2cmJX76Ra4lJnXP0Rewa3JR2lcgnoEI2cEhOx8rHeSfybu41c2AI+YJadGNU7SZe4fSBhXcwP0rf29CLacvWQtq7aFYCAgZyY1jvlNGM4WmhbKg89mQA6RCknnXaLc72TdGBChsMHlc/SeXRsSbf1bQFNIpAT6p28QksdxAccGx4gY7AAhwcAY0BOABgDcgLAGJATAMZgICfUOwEu8JAT6p0ACxjcd0K9k46HBq+k+5sEF/EtFk9FoN5JhyABAlMweGYP9U46QE5xgI2cUO+kml/TQ9EfqXV904QzmpGqwudLNHJKTMRCvZO5DdpDMQQiNNeZicaAO5wpzLIT6p1crev30ZSTaF3VIn2rE6mVLzCQE+qddPKDjxZ9OelM6E9OtEV2RCknnXYL9U6yPOMwJw3KtY/UQ8KQyj2dvSqNVBoXayKQE+qdvCJqAMQTHBse5Nm3eL6CwwOAMSAnAIwBOQFgDMgJAGMwkBPqnQAXeMgJ9U6ABQzuO6HeScdD1yvp/i61c4k9HFvuzoRsD/VOOUIzwFzISfwIcgoJ1DvlCMgJcvIgJ9Q7qeb3FJcYJvfY/dmSjlK5pE80ckpMxEK9k6EN2kMxxjyIPRe2fMMsO6HeSdM6MbMjLtEWr9hVcvK9f4hd4QoDOaHeibDlKVJxoM7SiXnstC2Vh55M6BOlnHTaLdQ7KXKIKihxHqldVRTSHRjz2GlbrvuHtuWJCOSEeievOFZJhJ6ED6/Y4+4fyBDwW9OrlXDMaRIrZ2gYuAgAFyAnAIwBOQFgDMgJAGMwkBPqnQAXeMgJ9U6ABQzuO6HeScdD16vJjC4384XBUxGod9JBM0DIKadEKSf7oUW9U0AgpzjARk6od1LN7ykuMUzVPBCeD6KRU2IiFuqdDG3QHooxetoJwBVm2Qn1TprWiZkdcbnaAvowkBPqnQhbniIVB7qGDDwRpZx02i3UO5E5RAxKnEdq1zUKcScAVyKQE+qdvEJLHcQHHBseIGOwAIcHAGNATgAYA3ICwBiQEwDGYCAn1DsBLvCQE+qdAAsY3HdCvZOOh9Jbt0ZmtjjEThsK7TYDg6ciUO+kQ5AAXafNj9jzXE728FDvFBDISXRD1S2HnuTagAPUO0mdcfVH7ClOK26Ik+t4yDF2zXmkoRGGvBKNnBITsVDvlMsN2mfXpcMldtpDS9ghnhaAJsyyE+qdNK17HUXAMXZNObna8goDOaHeibBFROrpIwKOsWvKSRKt20c0UcpJp91CvRP5PSq2qAIXR0l3hXQHxjl2eh6pXdcoXPeJcl/5G+Yb1Dv5wLECIvQkfHjFHnf/QIaA35perYRjTpNYOUPDwEUAuAA5AWAMyAkAY0BOABiDgZxQ7wS4wENOqHcCLGBw3wn1TjoeSm9fgpBh8FQE6p10CBIgMEWUcrIfeNQ7BQRyigNs5IR6J9X82bfihji5q4cql4AO0cgpMREL9U653KB9FnWr2gnAFWbZCfVOmta9jnIEC1H5g4GcUO9E2CIi9fSRCBTlgyjlpNNuod6J/BUktqgCF0cRu0JsBzpEICfUO3mFljqIDzg2PEDGYAEODwDGgJwAMAbkBIAxICcAjMFATqh3AlzgISfUOwEWMLjvxLTeycIt0ckHg6ci+NY7qT7StAjYweCZPb71Tl4NGRkLIoSNnNjVO9EdxAfn9D3EOWRsiUZOiYlY+VjvJPbUN6qaQcyTUFSsYJadGNU7EW645kZpB3tCU00FooWBnFjXO4mdVSdpxOTSt5BTDGFwZY9vvZPKFuEe4RKyU/yJQE6TvN4JAshjcGjDQ3WaB/IGHF0AjAE5AWCM/wLItnTQo2ebwAAAAABJRU5ErkJggg==" alt="" />

当设置完成数据表的CDC功能后,我们看一下是否已经配置成功,用下面代码

SELECT  NAME ,
IS_TRACKED_BY_CDC ,
CASE WHEN IS_TRACKED_BY_CDC = 0 THEN 'CDC功能禁用'
ELSE 'CDC功能启用'
END 描述
FROM SYS.TABLES
WHERE OBJECT_ID IN ( OBJECT_ID('DBO.WebManageUsers') )

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAXkAAAAqCAIAAADZDLyHAAAHOklEQVR4nO2dTZKyPBDH+0JYrF15BaviFWbvQtzODXRh4SVmNxZncGlZ7jwMzwIInaQTMnyZ8PS/uuYRaCCm6R+dwOsLGxaLxZpeUE6mzWYz3cEXL+69oMThKAd3ApRl+XrcR7fv72/ZsimOv2zj3gvKOBxaJzBrlmPce0EZh+PFrFmqce8FZe5wAID2wfEZrzHXh2wRsuZ3n0Jy/EWLq30ht162oG0FAHFqdv85rgAq/2oT0u7y+XjM0Xuyu1AP2L77VYAuceroOi0Ej3txSHRPJWpNUMjDqitdMVI8qwacdkTbtldqd7qRllMTzv3C8bi/EDhMaT7mYkS4iZQ1DS8eOmuuAnZimx5+WudVomeXZA2G1LLMgzWnnSTC7z61ZGBjpx120LrOGYLikLTBksmPdrmK5mZARsSgkjW38beQeylfDX1l1TobiU9NO/cLx+P+8qhrHLtEZHGyZrU/Ctsdcnt9nHYqiY6iucIu21RsU2bNn7++kzXKVi0EP8cVld7NEZS87WaNs9k6VurPxSEBcapg0d6EFOtopLpoce4VDrKEcZi79gncYmVNQebM7z6tryp0x17ti0t9m72K5Hjpl2yRmUdd48g907zrGi0Etk5u4gIuhJEr1ZZonmZdI7/pKkFDafcpnKfuddkMGUORTIkIMWQnRMWaqlZXC93ikMgqt84iBUynnQYpJazuQURk5jVfU02UtLMbDjNYY+k6PQSONDbnO8jD6kewlxXEfA3eZI+vL2t+jit0rxolHI/7y5jo7RxSRVfRmJ0QGWteGjvazAEAbVLm57jaXi/bel6T6xrN/7KFjq5w1DV4DsUIgYs1yfFXPfWIdU3HoM99Cuepp6lrMDvcrMFgigs3UbPmXhwSZf5Fed6k1PDFIUlXiVIHMWtasycw6WA++5OTu3oIOqdC0FBuzPka9bwdsf78fM3L7zmUm0eBW9ysqZ4CgKQJmn3Qa3h5ITJr5KSs5MKguqbdSoag+xGPrHHGfQ7lX9eE8RzKfwxlLkZhsbNGBt54nFldbeZFZp2v8Z8ojcB8eg+9O9M5V+VmTZWHlhB0v19TOWyvZER6vl+jenrcV0J4vwYvvpg1n2cNG/debDbwXT6IcHbG3QnMmuVYr9477fRLPdhnc0Oa+oGv6QiHZIqJEnO9g0fhG7Nmmca9F5RxOF5jseZ7GsmWTXT8ZYt7LyhxOL6Hs2YzpcqynPT4yxb3XlDicGwGsmbq0guMl5f4r/9fNragbChrhuzv0GazeT3uT1ZfAUz4C62sv2q6TIlF47BmdP5Vo7vX4w4An87ZWMUXd1DicITOmk8nbMTiuiYoMWtCZw3XNb3FF3dQmjMcttsMXi8/+ziPoulY0/lf9PWua25ZCiJHC+1SLtCCskea3YjDYO9blgKYbiMrF0oDtcUx1XWtFF/wVQwJPusvcmTa+7yW7+bVIcGrQIkT4WyIDL0GF/zXJttxbHIcqpyGNfK3BUZgDVnXIHTcsjRN8RKZujbWoF1r9CyINfbQysuVWTOfbOF4n9ewPr/rpeKrisr7vG5Xvs/rOlSks5nwZtqTPv1QQhZH5Ek9e8BTH6lrns9cNFDIRZrlkiS2zLWyJstEsyEXqRCE28jiuuY/lSXTFKhYV9eLFueyLNWyxafc+Csyls8asq5pU7T695alIn9ipFRFCjSFyi1LUyHqVU1uV955DRsMrRz9/wNELqkEeH/dRzlpUx9pzSDgUi9Kx672i0zztKsrtMyaWUWHw0YPfX3xBV+FCzXdCCArFJNHPqyxydK0WqGzxpJHNVUayFTAkKjRxljZDU3qtMMsuSnNbtURzPLH2J0okdq2aD5GM6ysaVbWxyDb3yBR8XSpK/bMmlk1jDXv83p9LoayxtxKHseNks4T2RQ6a8DyHOqWpSLX4ILzEAuPslCWYl7J+kivRwA0Bvn7mM3AsFBYU7saRY3ZftXTKa5rglJodU1n/WLTYlljzaRcgBAC3f5FVhc5xD3fBgs5QElTOVa6odkgtfbBu3v40KWHWhepS7kAAJG72489XajhuiYszTZfY/usfbCVOT51jdvBptBZA9b3a9R0ywW626vDGTV79THU06x0UOlRIYVmjepDj6HMs6qFTVvWYP5R7W+baowTLeK6JijZwjH8OVQlW8676xoTEDZqkGz6P+oalHY44xUSydGGOWtLZiuqdAD7U2WR7vMkz6I2A7VcW63PDZvtt3pa1RV7Zs2scmTawPdrNDo4WIM/4L3MTWYjQ2bNIIv7veEJH2T/QQNDyxpX84SDrFPIDyQmMIZMmadYFGs+nbD+wg/BJ39Lx0edsWfNqRlYY1Y0Jgs0amCOkDQxdyc3aeciFTproqxrwhDXNUGJwzEOayb6xcCo6prgxHVNUGLWjMCa6X4xkOuaIeKLOyhxOEZgzdQGAfyYZrx/2dgCsYGo4iqdxWLNIWYNi8WaQ8waFos1h/4BPWmoOGpfUVAAAAAASUVORK5CYII=" alt="" />

当我们对WebManageUsers表修改数据后,可以在DBO_WebManageUsers_CT表中查到相应的结果,从表名中可以看到,CDC表的命名规则是架构名_表名_CT,呵呵。

SELECT * FROM cdc.DBO_WebManageUsers_CT

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAABDkAAABSCAIAAADRkJjJAAAd50lEQVR4nO1dvW7cuBrlC9kwMFWmyisYGDdpbqc+heMyeQNPYdiYzsViK1dJoNrbGespjIWBFAMXQTpji3WXjreQRPFflChKJHUODgxZI1H8fkjxiNQMeX56AEEQBEEQBEEQjI2EpoPZnQWCIAiCIAiC4GQks9fAne/fv5+9DiAIgiAIgiAITsOUtMqXL1/mntpxwuyOAkEQBEEQBMEMmJhWSWJqJYlKgiAIgiAIgmDk1GiVYrfXclXInLiuWq1yf39/f3//VcTt7R8z+rSa/5mxAiAIgiAIgiCYAfVaZbenNXe0MNCuVQghln+HUatVdru9tATr9fW12O1m9Gkq8z8gCIIgCIIgGDOd5lXUGZVVsV+tvLQKMcNUpl2rvL297f+l+3/pn3//VxTQKiAIgiAIgiCYNjXCgJ+peHx8ZNv39/fVxu/fv3e7/WpVGAtt9IZFivCaxLQt0aJVfvz4sd/vHx8f//z7v91u76lVLHVwmSCCVgFBEARBEARBf3ZoFaZPKKVfv36thMrb29tut3/37p2+xC41wvaMNa+y2++/fv262+1vb/+o2EurqBXWbrjXFloFBEEQBEEQBP2pGWrf3v7x48ePx8fHexGVHqjeXLdrFXUQr9UqndsSHd9X+fPv/+oJlv1+t9+/vLx0e0EUJ/xfe62gVUAQBEEQBEEwEPVaRTuvstvt397eqtdCbm//MGmVulzDjAR/wFjzKr9+/Xp9fX19fd3v6Z9///fn3//xdV6tChe5oq38sNpCq4AgCIIgCIKgP13XgP3+/fvr16/s/XW7VrHoDZ/jTVrl5eVFmPzZ7yuZQnfFbrd/fHy0yJVO+WSvIbQKCIIgCIIgCAaiZqh9fX293++roT97FaT6y94J2e12nWvA2Eoq7dDfDm3JjmvAaq1CKaX05eVlVRSrVeH4TQCWjzCvAoIgCIIgCIJTUq9V+DVU1cv0b29vt7d/7P+l1Tqr6+try+hfuEDXG/bPuvdDtLRolWrC5/X1df9vo1V2BS0KSmmxW+12+1XRXVvMq4AgCIIgCIJgPOzQKtW6L/aOCnshpFOr8PMq/E7pGNOGlnatUgmV/b+Un2l5e3t7eXnZ7W3fsGyq3jPmVUAQBEEQBEFwPuq1CvvWL37dV/X1X9cNTKN/aQRvmqYwaZhha8CYUNnvG61SFLRY/fr1q9itOrUK0S1XM9Vk2PwPCIIgCIIgCIK9qNcq7969W60K6S+/UcHpAkO/+Vdlt1bZ02K/Yt9j9vr6+uPHj/v7e/dfrrR/5DgRBK0CgiAIgiAIgv7s94Vd89KkVR4fH6tfhKxYa5ViRYvV4+PjqlhZtIrL6zTPilax7DTVEwRBEARBEATBXsxBq6yK4n//+9+qKCpWWqX+LchmDduA91VMr9xIK8SgVUAQBEEQBEEwBJPXKiorZaIytnqCIAiCIAiCIGhhhlpldqZSTxAEQRAEQRCMmelpFQoAAAAAAAAAwAKQklYBQRAEQRAEQXA5JM9PD18AAAAAAAAAAABiQj2v8uXLl/cAAAAAAAAAAABx4PnpQdAq4daZBS0cCI38wpefRcvBQmK3EDN9ABfR7JyQqDmJVptHBiaYkLFpMWAC92q0SohFZrwQmn3FG9iX+YUvP4uWw4XEbiFmwkVwQgbmJFrtzExYoGkxcDL3QquAHcwvfPlZtBwuJHYLMRMughMyMCfRamdmwgJNi4HQKmAszC98+Vm0HC4kdgsxEy6CEzIwJ9FqZ2bCAk2LgdAqIq9Oz64C2P/t48nxxzKkfzPgnOEzBcgvcPEm5EgGZswEYpe6mfPmnvPVjS769vGEELK5bPbcXRwTEtyiyzNyemP8t4/hVf0b2INoc8KIJn/7eEKOLr6FKdw9pm4+CUKryY7V7lFzIRki8LxLawpzsw5umk9ezW1aDJyszSagVW42jbltg+Hc0ZkrlmOQag4MGL5ORqlVvCzyNHzxjDp2/AjDL3z5NTrfq7u76NvHk+OjtpDqlpmWVmlre3dxbLvNj6lV7DdK3oezjJjDX32gc9yj4F5zSbjO7Hm31qTWrdoz970siJ6Pw7QY6Obejn7MhdFrlatTcvyxvDo9u9JZC60SngHD18kItYqnRZ6GL55Rx268qOXX6Eb3of0eebFpnkZfnZ5sTsPXPJBWGWmUPEZQLjZNLs2rVQb4diQPeEfBueZiMszueafWlOK8imfF5jYtBo4v1A1MQatsLvn1DOX5UfXE8OT88uKYkEblt48Sq/mmbx9Pjk/Pjptd1lbElXnHeofZppsj47jh42YGjy6+Pei9zc8eBghcsIS80xiomsNP6zfbuuxdeic4Qey40JzePEmdRjOq0GRsdczpmRC1u7Y70qznYeVPnqLqM+kOM7U96h3f2WqSXCJ3CdZRVw1ETnVdKy6fHp6fLs9Mzd/uoqqEq9PmckcXV3WZ2lYmhUOtnqY70piv1yodnQOXSzfGSTnbALfHOExKRdUu7lGxpkOWsrrrnisFvTth3M0xXV3xtvDv1WljOPPn5RmLAu8ZKShS6H2ioOkWam8Y+/9IPK9rTd2dp1p5h5qMzn5txLHXwrxKb/c27U5JA7mTrHp+MbefE9AqT3dCwxMM5vp31UdsRNg9r6KUSYI/xkiIo4bv7uKYG6bXYZK8zT0Mrp4Qjx24gAmpGsjvacy52XB3U2mVDjpBK8fORm6Us7lk0pELjTZjlXutfkihLX/yFNVqFY2Z5kYn56Sa5Eod+O7X1A+bWnG9s2NA03GPZOVoW5Ox81Grx3lGbdGCslK1SlfnID220GsV7qy+ThBTQkhF1S6LT7ghsv5JinrPFYLukDCd5rRjRUPrk71tcP7VqagHLJ2Aw52oR7WbEbzdG2ZxMpvn9a3J1rm1e4TjnWoyOntEx73Xwm3axb2afkxNA7Wdsqd4l2fk6OLq4wk5ek5Bqzw8Pz08X52eHB8RUplqvg3zj0CMXb/qza5b+9zZMC/HDN+V1DtwD2melG7a4n+/wIVNyE4Dnww3Em32guFi15l70oNVbUAtfY5WJEyfoo5marPUZJ3kE3UkrXa/pmLVVlx91PWmTdc98u7i+PSmmmLqtMjFat57GvO1WsWnc5CKGuYE3b/25DT5hEkyUyZo77k2j3mYo219uicR3L/1cL+eGdhcPldzBRbP+LdW4axmEKb1RvfoZV7PK62pM6NYr9KzJqOz57yKW68FrdLbvZdn2vupZUjPlfOckFY5u3ooz4/4fkeYN+efw1l6HIniR0qZ0Cpjh29zeiLdd4eN5/wCFzYhOw18eqifMVw5ZC8YLnb8wmvLDdgY0K4+Z26t0s9MuWJW6zqX3Rvv+kqxzSliC+p+06bzHlmeH50cH3FPo62tzP0Yvfni7IfNNG0umbXKCKPkEbUKn1EO91ybxzzMedK1Psnb6r9XpyfnH8+qmh9/vDk/kmcqwmqVZnGmxhtOo5d5PS+3pr4Z5VyT0TmGVjE4HLfpvl2QOQ00ozjuxOf4tcrNhrC11zcbcnbOz89Ko73GBdV0rbtW+WYqE1pl7PBdiQsP9AJDnFy2aJWhgQuYkN8UA/lujltIUK3RlBeSPSnZC4aL3ZV2GUMdCP1SGfn5iL3P0ZU/fYpe6eppNrNpdJacVJNcqYbtrq9WRteKuwY33fdIVoLl0hqtIh6jXwOmMf9mw4mrdlRq7Ry6tcpY3wPWZw1YR5XYe0QO91yrxzzMMbQ+KZEE59c1514/YCuyTI3U4U7Ur9rtbJtyj3AZvczqebk1OXSeQka51mR0jqRVdA7Hbbr394Dp+kBTJ8nWgCWhVdhMLiH1qgDxRZzqLRzhLUZ5VpQ7Ri6ce2bQluk8nlgIxw0f9+KUsh5U6BarOB7p/e8XuJAJqRj4VK+Qls1pm+jDsy17wYCx4zKN3ZmOhD1qQMUnnULUWFejyeSRntQOMrOtZ5WBWjOVRme0TvWJWgfjXV8t1tiKy/OjcdYLmS6tC4davdYzrbu05nNuVzJE3znYez9CiM/vq3CFsNcJ9BEnhmUthud9bOBu9KfmxK6E6RvTzkTSOF98/4QtMrQ30vojw52oX7VZBWRvdHsyHs9bOjepmcgZ5VST0en++yrtFHRnrwWt0tO9XD9mTH7zu/VpaJWH56c0fr4tV+YXvtksQtfmzbCxiyZACzFzZhf1d2nAn1Sa0QnR2JXoT4wnWu3MTFigaTFwMvfOqFVa8WTGuBOF6hXnWUCZFiMI38iBm82iLMaI8zJs7KIJUGpmztC1TnWP5E2b9HlwYCfEaFeiw8pEq52ZCQs0LQYuQauAaTC/8OVn0XK4kNgtxEy4CE7IwJxEq52ZCQs0LQbOplW+hAEzJlD5QFDkF778LFoOFhK7hZjpA7joS3ZOSNScRKvNIwMTTMjYtBgwgXtlrRIUlNLQlwDCIb/w5WfRcrCQ2C3ETB/ARe+zc0Ki5iRabR4ZmGBCxqbFgNDulbVK6NkiQgj+Jv0XBEEQBEEQBCejrFVoGFSF/wMki+enB0p/5sRw2Q6ExkJitxAzfQAX0eyckKg5iVabRwYmmJCxaTEg9PhQr1VG10OscELI3ENuYCAIIbOrC2gVoMJCYrcQM30AF9HsnJCoOYlWm0cGJpiQsWkxIDetMvd4GxgOzKsA8WAhsVuImT6Ai2h2TkjUnESrzSMDE0zI2LQYkJtWwbxKusC8ChAPFhK7hZjpA7iIOjiBEKLdthzWiergXqc4ItGY2qutOsrkOrbfxbfjRiFRz7vA0TR3n/eCPUzhmtJkiEerXJ55/LZX57zK9ab5TarNteMBgfZ8/3RCBGyuNbvCVqnZLfviekNOPn2XPTLCtcSSDTDm4uHzmqy2B+7f9ecD/UnpbUE+lO2Rzb/tAeopsWiVsmgcVZSOBwTac9iuxewrSs2usFVqdsu+KAuy3h5kjwS5ugyX2FkLSAMxpGjkWEgm2DGjVuE3xkqeREfMPlEwfdQZESkKpAueJnTjsF2vt4cmGfolguXc5qPBCK1VtP5XT7GcK0G6z0feiYUeH7polbuL48pXI2gVop1X+f7ppB4pt1sdB4TbI113c62vVMAKMG0k6onvn04IUxTXG04ynXz67mWsULIRxDSvcvi8JoSw9MpAq7TdoqGDVA8It0e6blHqKxWwAqzPFHvLw3ZNmFYpC04yrbeHYdc6bNfNRbhNHYyxa/WTRlwlh4lT1N3/8WAhmWCHzxP9waNb6aMRkyczreLiYe241gWdAepV2nhaZVCjs5wbvVahTaClw0xRsLa1w3atajWdXvF2y1iwapURxodxzKtwUwia2QTtAeH2CJeVhviTVEm9wD//VJXYbJqKqPMgw68llmyGLRfXn7cFKcpctArXVep7XPWAcHuEy0pDzEmqpF6A0qoSRbFuR4NSlbyNtXfCDjeeaHpxD0ydohxScd9CMsGOUVYfEfOj3756xtPjmWkVCSbnu+gZlyi4h2mwCTZUsR+WAZZzJ9QqnU6zHEMUfUIcFKP0qXo7bfbH24+FHh9OrVWIbl6F1wL1nAI3wSBNbFTb4fZoqmWYcQlcAY1yEWZelEmXgdcSS7aAWOZV1p8PLMPS1yp8r1jPKXATDNLEhtq7jrtHUy3DjEvgCmiUizDzoky6eBk7eF7FtYA0MHGKildIw30LyQQ7LE4wDZKk/ep4qxPmwzCvIsNdPzg633I8ETUnMUtQFSYT2tV9zcN9NtveTs2yI9brNXesz7niR/WTOv5ctfC+pklw8ZLlGLtW0UZcLlBd0NCYy9ZVCLuarnwrLnm1ekZZrdleq3H7uijqG0vJ32FMsGsV//FhFPMq6hj6ekNOPl2zAfksWqVa/1VvER6b66m1Sr0tqKfNhl8pNvRacskWdOQi/VlW0jk7rbLeHsqibrGsq51eq1T9lNittJ3LtFql3hbUU92zcX2dn7H2rtF+46k8lMH4dOIU5cvvuDVFg4Vkgh2W1UfUvNqEiPrEdJgJpk/9kydLreK43+5zxxIGRLOCk/Lnl2nVspRTp9WkgG1uxP1c5SP5XLVwD9MopWO8r2L5K21oW2I9e8IZyN9ni1L0AOvKiXI0g+apJz+hXp/fysg6JkwamldzcAg9PoxxXqUZQxNhldLUWkVaJDXnvIo6wfP900mzBqyeYvG8+gjzKlW28QI6I61SP4do2vccWoWTCrpeY8oKCBKFPQAS7y4+13IZ67it/El+kDpxirLtVIQKXUwm2OEyDpOUifqRdjjFH2OROgyjJE+WWsVRP9gPcIwCO3g0E/gHZM1QmvATI/bOZdi5mh5KPFdTeH/T3KLjfgx10yqmnbVWYfdbQTa00yqC97RduckzdjFjCoG3VvEcH0Yxr6J5j6KaymDD58nfVxHG7jO/ryJP65x8+t68ScPVbsi1dCWb4ZCLPw/b1br40Pz713at+/6H6LWKZh1/1exZW538fRWho9D2GtO9r8J3gU03yC2klZ6d9b2W41jHZTTT1bsmgKlTNDWhQheTCXZMoFU6C6HjJU+WWsVlP1Hkh/ZEeyjtGGQC9wKF8gSL8KuBqTp69jjX+uSMkKI0F+5sGqVu0RkQwcFaRVg6J61Y4I5qvadxlNkzs2kVr/FhFPMqyvdT1XMF7Qvkw77katgeVZ1otUrYCijKRa6IoGTEVVwDrjXWvEoljtvvfCjZC1X0Jy0/kOJWr0xi0yrCHHQ7Q9q2fvmAkHvU3kXba4StANW+ws0dIYx1xUVpfa7Vfp1YBywTDvwK3NSfpk+dos7+jwcLyQQ7Ogf32hGVtN1Xq8j/jpc8WWoVF/Egeb7X+HjAMc4miE816v6GH8O2Taz+RNAqg8/VfSScqxTe2zSbc+bRKnZLJA+UFq1i8gzfH5rXgAXQKj7jwzjmVYTf/fhUv1Df7K7G0JP9vopGJsjTD8GrpKuEoihG/X2VUd5XoY10br+fjv7VPoPnv7SO92Zxq9kzr1YRXj3bcktBy0J9pY9r9IH2aL6CiwgIXSVdJajcfZWF/7X41wGJdUrfJXYZPEqfOEXd/R8PFpIJdvhoFXWnumEvp/o7YvJkqVU697vEyHKkVJSlZAtsyl8MLdvDyYrq/7U0evY5V/5IOVctvK9pFv+4+FB7jKXhaMMkR/Cg/4Ji7sPGXOO8itYz7CZufrfeJFHG0SrDx4fuWsWL+N36DEBM8yrJMtE7IkCTHc30xULM9AFcRMN8Z7E03mUfMfB7hlXbhERj6jOvYhrCmiLlEgXpGE8TUofnrJd7BIkkPJRPtcFVIqVbax0xjFpl1NHadFpl7vE2MByhcxFaBXDHQmK3EDN9ABdR52fGjoPXvqPeXqNhFyQaU88n99QqOahbFOzjbB8TUseUa8Ckba2kca9GEshNqxDMqyQLgnkVIBosJHYLMdMHcBHNzgmJmpNotXlkYIIJGZsWA+bRKl8CAPMqqQPzKkA8WEjsFmKmD+Aimp0TEjUn0WrzyMAEEzI2LQbMoFXeBwPmVZIG5lWAeLCQ2C3ETB/ARTQ7JyRqTqLV5pGBCSZkbFoMmEGrhCYhBH8T/QuCIAiCIAiCU1LWKoFUV9DCgQnwjDVgQDRYSOwWYqYP4CKanRMSNSfRavPIwAQTMjYtBoR2r16rjK6HQgshYAJAqwDxYCGxW4iZPoCLaHZOSNScRKvNIwMTTMjYtBgArQLEAmgVIB4sJHYLMdMHcBHNzgmJmpNotXlkYIIJGZsWA6BVgFgArQLEg4XEbiFm+gAuoj1/t36sX3hgP+jhfoojEo2pvdraH06xH+ni23GjkKjnXeBomrvPe8EepnBNaTJEoVVuNs0vCW0uA2mVsmguUZSOBwTaI/9YKClKza6wVWp2y74oC+63S9lpI1xLLNkAo1Y5fF6T1fbA/bv+fKA/Kb0tyIeyPbL5tz1APSUWrYKEnCshOz1fobNndEnp+BFDikYOFxclYspwzKhV+A33rsOOREfMPlEwfdQZESkKpAueJnTjsF2vt4cmGfoF3nJu89FghNYqWv+rp1jOlSDd5yPvxObXKuX5USNR7i6OydlVAK3SZqEhH9UDwu2RrluU+koFrABLUTE5D9s1YcOvsuBGqOvtwctYoWQjrFqFECY2MtAqSEihxOkS8rBdNxfhNnXo6BndUjp+TJyi7v6PB0YXtWq191g5Ofg80R88upU+0iWPoevwMydamKrt4mHtuNYFnQHqVdp4WmVQo7OcG71WoeLv01PR/9o2aG5rh+1a1Wq6ZuTtlrEwv1aRdMvJ+d34WoXLTH2CqweE2yNcVrqjT1Il9QKUVpUoinV785WqNPxaYslm2LTK+vO2IEWZi1ZBQmoqMFlCchcw56S1Z3RN6fgxdYpyiOYm2AGHe2QqpgzHKKuPLI9+++oZ0eOYVxFgcr6LnnGJgnuYBptgQxX7YW3Ocu6EWqXTaZZjiKJPiINilD41LQqoBwBRIiqtEmpehU/C+jkM9zxXeo6sJvO4ezTVMjzgDlwBzUBReNCtPOMeeC2xZAvsWuXA9Eb6WgUJqavAVAnZFjB0XsU5pePHxCkqXiGNyYjue2QypgyHxQmmQZK0Xx1vdcJ8mORxaJUe+sHR+Zbjiag5iVmCqjCZ0K7uax7usymzdmqWHbFer7ljfc4VP6qf1PHnqoX3NU2Ci5csx9i1ijbicoHCbVUw/tCsqxB2NV35VlzyavWMslqzvVbj9nVR1DeWkr/DmBCRVinPj8jxxzLA+yrqLbMsagexzJ5+aFilRb1FeBTl1EPDelsYrNaJxKXWkGvJJVvQoVXoz7KaWslOqyAh+STktwMkZGusvWs094w9Ujp+TJyifPmpLKGz3yOrtpK5UrGuPqLm1SZE1Cemw0wwfaokD7SKq2K0HOlesimULiU7Kf/1tl2mVctSTp1WkwLa/rf3ucpH8rlq4R6mUUrHeF/F8lfa0LbEevaEM5C/zxal6AHWlRPlaAZ5D+875nFORtYxYdKw2RjDvYPhqlV8hMoArVLLPn6V0tRDQ2mR1JyPsYURIdPbYmP2vPooWoXS24KfYMlIqyAhp0lItt05UO6M3dK0yigpyrZTESrUdQ1Y5nLFZaAgKRP1I+1wij/GInUYdMkDrdJvXsVygGMU2MGjmXCQ5jcOwrP2zs5l2LmaHko8V1N4f9PcouN+DHXTKqadtVZhjUaQDe20iuA9bVdu8oxdzJhCkIRW8RQqnVpFs2y68jJzzeSvBwhx0QZputcD+Ixrso5bt3gQH1X0uZauZDMctMrPw3a1Lj40//61Xeu+Hyx6rYKEVCswSUI2pTsMlA2x65fS8WPqFE1NqFC3e2QewtWCCbRKZyHUmDzQKv1W4tmdbD/AMqSWBtZ9TOBeoFCeYBEirriVR88e51qfnBFSlObCnU2j1C06AyI4WKsIS+ekFQvcUa33NI4yeyZbrXJ1SsjpjYdQ6dYqrReYn8Q0lA8IuUfeNgQpbAWotn/njhCGFuKSlwHXGmtepZo8ab8TrF4VVn1UfiDFrV6ZxKZVkJCay0ySkGXhuGCns2fMY3g6dYo6+z8eWKaeuInA1Kzqic7moB1RSdt9tYr8rzF5oFVc51Ukz/caHw84xtkE8alG3d/wY9i2idWfCFpl8Lm6j4RzlcJ7m2ZzzjxaxW6J5IHSolVMnuH7Q/MasOS0SvvjKoQQQoJ8D5jwps+WW3lXFuobVJyPA+2Ru9aD/HMWoaukq0RdkTZbymK8a42oVX4etqv2+4vpX63v+C815r1Z3Gr2zKtVkJCaJJkiIdt/Obu0WLpWCZOi7v6PBy4uSsIQH/hoFXWnumEvp/prTh5olSGjYdMppiOloiwlW2BT/mJo2R5OVlT/r6XRs8+58kfKuWrhfU2z+MfFh9pjLA1HGyY5ggf9FxRzHzbmHkxaResZ1hKVW4Hq1uS0yijE79ZnAKNWSZZIyHSxkNgtxEwfwEU0zHcWS+Nd9hEDv2dYtU1INKY+8yqmIawpUi5RkI7xNCF1eM56uUeQKNJR+lQbXCVS8iPJyB+4QKsAsQBaBYgHC4ndQsz0AVxEnZ8ZOw5e+456e42GXZBoTD2f3FOr5KBuUbCPs31MSB1TrgGTtrWSxr0aSQBaBYgF0CpAPFhI7BZipg/gIpqdExI1J9Fq88jABBMyNi0GzKNVvgQAtErqgFYB4sFCYrcQM30AF9HsnJCoOYlWm0cGJpiQsWkxYAat8j4YkCtJA1oFiAcLid1CzPQBXESzc0Ki5iRabR4ZmGBCxqbFgGm0yv8BxupdIi2TWXkAAAAASUVORK5CYII=" alt="" />

从结果中我们可以看到,CDC对于update操作是进行了修改前和修改后的两次捕捉,非常清晰!

 
好了,对于数据库的CDC功能今天就说到这里,希望对各位有所帮助!
回到目录

方可补不足~用CDC功能来对数据库变更进行捕捉的相关教程结束。

《知方可补不足~用CDC功能来对数据库变更进行捕捉.doc》

下载本文的Word格式文档,以方便收藏与打印。