I can successfully capture change data from mssql CDC by issuing the query
cdc.fn_cdc_get_all_changes_capture_instance ( from_lsn , to_lsn ,
'<row_filter_option>' )
Here, from_lsn
is the min_lsn(oldest uncommitted transaction) which I can obtain from the Database.
But I have an already committed old transaction which I want to replicate and so I obtained LSN for one of its rows and tried to issue the above query using the obtained LSN (from_lsn) which failed with the following error message
Failure in executing queries SQLException;ErrorCode : 313;SQLCode : S0003;SQL Message : An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_ ...
Is it possible to capture past changes from MSSql ? If yes, some guidance would be appreciated