Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

CDC and LSNs Expand / Collapse
Posted Friday, March 1, 2013 6:24 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, July 27, 2015 7:46 AM
Points: 766, Visits: 892
Hi peeps,
bit of a departure from my norm I am looking at using CDC from source systems to populate a data warehouse. Currently I am looking at one SQL Server 2008 Database with circa 20 tables. We may add other instances of SQL Server at a later date.

Are the Log Sequence numbers totally unique so if I want to move my changed data with LSN's between 0x00000001 and 0x00000100 then all i have to do is access all 20 Table value functions and each time I pass the same two LSN's

or are the LSN's specific to the capture instance ? I am guessing they are unique for the database where CDC is enabled?

Many thanks.
PS are there any pitfalls wityh this apporach to loading a data warehouse? Planning to use net changes in the settings to assist getting the data in quickly.
Post #1425463
Posted Monday, March 4, 2013 3:12 AM



Group: General Forum Members
Last Login: Wednesday, July 15, 2015 6:59 AM
Points: 134, Visits: 446
With no warranty : AFAIK the LSN is unique for the database, anything else would be horror :P!

Query Shepherd
Post #1426152
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse