Hi Everyone, I came across the topic Change Data Capture and I have few questions related to that, 1. For Enabling the CDC to the table, Do the table should possess any key on a column. 2. I learnt that, The CDC can be used for the situation where the Replication is not possible. If it so, The CDC Table may have the changes recorded, But my question is whether the synchronization process is automatic, If it is then, How it could be done. 3. The Change tracking mechanism will also help to track the changes done in the table, So please let me know the extended feature of the CDC. 4. Then please help in understanding the Extraction, transformation and loading process Thanks in Advance. Regards, Ranjith Kumar Mohandas Ranjith Kumar Mohandas

This link might help you best place to start for CDC http://msdn.microsoft.com/en-us/library/cc645937.aspx Example to setup CDC http://www.databasejournal.com/features/mssql/article.php/3720361/Microsoft-SQL-Server-2008----Change-Data-Capture--Part-I.htm

1. For Enabling the CDC to the table, Do the table should possess any key on a column. You should never have a table without PRIMARY KEY in a relational database. The only exceptions are staging tables which are used for data movement. Related link: SQL PRIMARY KEY Constraint The PRIMARY KEY constraint uniquely identifies each record in a database table. Primary keys must contain unique values. A primary key column cannot contain NULL values. Each table should have a primary key, and each table can have only ONE primary key. http://www.w3schools.com/sql/sql_primarykey.aspKalman Toth, Admin/Prog, SSAS, SSIS, SSRS; SQL 2008 GRAND SLAM

I came across the topic Change Data Capture and I have few questions related to that... 4. Then please help in understanding the Extraction, transformation and loading process Ranjith Kumar Mohandas Note: only item #4 is related to this part of the MSDN forums. At the moment I do not understand your goal. Specifically how CDC will be related to ETL. Besides, there different mechanisms to implement CDC, but the most common is not through SSIS, but rather some custom .net coding. So to save on time I am giving you a short overview on how ETL is implemented in SSIS:http://msdn.microsoft.com/en-us/library/ms141263.aspx Strategy for SSIS: http://www.mssqltips.com/tip.asp?tip=1923 Creating simple ETL: http://msdn.microsoft.com/en-us/library/ms169917.aspxArthur My Blog

Make it this way, CDC will generate the change details which needed to ship Middle piece, in-house made or third party software to enabled the transfer, or say ETL software If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer. Sevengiants.com

1. For Enabling the CDC to the table, Do the table should possess any key on a column. You should never have a table without PRIMARY KEY in a relational database. The only exceptions are staging tables which are used for data movement. Related link: SQL PRIMARY KEY Constraint The PRIMARY KEY constraint uniquely identifies each record in a database table. Primary keys must contain unique values. A primary key column cannot contain NULL values. Each table should have a primary key, and each table can have only ONE primary key. http://www.w3schools.com/sql/sql_primarykey.aspKalman Toth, Admin/Prog, SSAS, SSIS, SSRS; SQL 2008 GRAND SLAM

1. For Enabling the CDC to the table, Do the table should possess any key on a column. You should never have a table without PRIMARY KEY in a relational database. The only exceptions are staging tables which are used for data movement. Related link: SQL PRIMARY KEY Constraint The PRIMARY KEY constraint uniquely identifies each record in a database table. Primary keys must contain unique values. A primary key column cannot contain NULL values. Each table should have a primary key, and each table can have only ONE primary key. http://www.w3schools.com/sql/sql_primarykey.aspKalman Toth, Admin/Prog, SSAS, SSIS, SSRS; SQL 2008 GRAND SLAM

Hi All, Thanks for Everyone. Regards, Ranjith Kumar MohandasRanjith Kumar Mohandas