• If you mean that you want the captured data to be retained for 6 months, you can use the sp_cdc_change_job procedure to configure it:

    https://msdn.microsoft.com/en-us/library/bb510748.aspx

    Keep in mind that it can get to a considerable size if it captures many changes from your tables.