Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Change data capture
Karenh
Member Posts: 209
Has anyone used the SQL Server 2008 Change Data Capture feature to track changes to values in records?
The client where I work the most currently uses Lanham's History for that purpose. That works fine, but we are at the point of needing to add more history tables to the license or doing something else.
Since the client is using SQL Server 2008, and that feature is built-in, I was wondering about using it.
I realise that I would have to create forms to access the data.
I am interested in whether anyone has experience with this.
The client where I work the most currently uses Lanham's History for that purpose. That works fine, but we are at the point of needing to add more history tables to the license or doing something else.
Since the client is using SQL Server 2008, and that feature is built-in, I was wondering about using it.
I realise that I would have to create forms to access the data.
I am interested in whether anyone has experience with this.
0