CDC and LSNs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » CDC and LSNs

CDC and LSNs

Rate Topic

Display Mode

Topic Options

Author

Message

Ells

Posted Friday, March 01, 2013 6:24 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 5:06 AM
Points: 379, Visits: 676

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.
E
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

SQL Pizza

Posted Monday, March 04, 2013 3:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

With no warranty : AFAIK the LSN is unique for the database, anything else would be horror :P!

Greetz
SQL Pizza

sometimes you dont see the pizza for the toppings...
seek and ya shall find...

Post #1426152

« Prev Topic | Next Topic »

Permissions