Stack Overflow
Stack Overflow

Questions tagged [change-tracking]

Change tracking is the process of recording changes made to data as they are made.

356 questions
3
votes
3 answers

Auditing record changes in sql server databases

Using only microsoft based technologies (MS SQL Server, C#, EAB, etc) if you needed keep the track of changes done on a record in a database which strategy would you will use? Triggers, AOP on the DAL, Other? And how you will display the collected…
GRGodoi
  • 1,946
  • 2
  • 24
  • 38
3
votes
0 answers

Ef Core - auditing changes and including navigation properties

We need to implement a comprehensive audit log of changes for an aggregate entity called Project, where users can see what changed with each save and the before and after values of those changes. The entity contains a few child collections (for…
Amay
  • 106
  • 7
3
votes
2 answers

How to set change tracking on a Visual Studio database project (SSDT)

I have a SQL Server 2005 DB project and am looking to deploy the Schema over an existing DB that is on a later version of SQL Server. The issue I have is that Change Tracking is enabled on the DB I wish to deploy to and so the first thing SSDT wants…
SQuirellingAlong
  • 61
  • 3
3
votes
2 answers

How to track changes with shared, immutable reference types in Javascript

Consider the following example: function add(x, y) { return x + y; } var collection = Object.freeze([1, 2, 3, 4]); var consumerA = collection; // expects steady data var consumerB = collection; // requires the latest data var updatedCollection =…
user5536315
3
votes
1 answer

Crippled performance when inserting to fulltext-index table on Sql Server 2005

I'm trying to a big insert of records into a table that is fulltext indexed. I have change tracking set to auto. The records are inserted from another table, in numbers typically about 50,000 at a time. On SQL Server 2008 this takes something like 5…
Tim Rogers
  • 21,297
  • 6
  • 52
  • 68
3
votes
1 answer

SQL Change tracking SYS_CHANGE_COLUMNS

We are running SQL 2008 R2 and have started exploring change tracking as our method for identifying changes to export to our data warehouse. We are only interested in specific columns. We are identifying the changes on a replicated copy of the…
Scott
  • 31
  • 2
3
votes
1 answer

What happens to change tracking value when it reaches bigint limit?

Let's say I have enabled change tracking on 200 tables in a database. Since the change tracking value change in the scope of database. What if I reach the max value of BIGINT?
user3057235
  • 51
  • 3
3
votes
0 answers

Entity relationship with two instances of the same type

I have the following model: In the database, suppose I have the user Administrator and an artifact which is created and modified by this user Administrator. The code bellow is not working, and I would like to know what exactly is happening and how…
natenho
  • 5,231
  • 4
  • 27
  • 52
3
votes
1 answer

NHibernate: Find dirty object in child collection

I try to find out how to identify that parent object is Dirty when one of the objects in the child collection was changed by using the features of the NHibernate context. I mean for the following case: public class Parent { public IList…
dmitrygrig
  • 61
  • 6
3
votes
0 answers

C# WPF IChangeTracking IRevertibleChangeTracking implementation

I Have WPF Page which has one Datagridview with radio buttons columns (Requested,Proposed,Confirmed,Cancelled) and a Search Button, On clicking that it shows following data in Datagridview about 5 Rows. It could be more than 1000 records or 1500…
user2264732
  • 31
  • 3
3
votes
1 answer

How can I do generic field and component-level change tracking in NHibernate?

In my application, I've got a few different types of entities that I have a requirement to do field-level change tracking on. I've googled for this and only can come up with examples on doing simple "Date Inserted" and "Date Updated" audit tracking…
David Archer
  • 2,121
  • 1
  • 15
  • 26
3
votes
1 answer

Change Tracking on a mirrored database in SQL Server 2012

I'm working on a datawarehouse on a SQL Server 2012 Standard. For the benefit of our ETL process I want to enable Change Tracking. This is easily done, but this server is mirrored on another SQL Server 2012. What are the consequences for the…
8x0
  • 33
  • 2
2
votes
1 answer

SSIS or Sync Framework with Change Tracking

Until now, I have worked primarily with LAMP applications, but have a project in which I need to set up two-way syncing between two SQL 2008 servers (one is web-based, the other is inside a firewall). I am finding a plethora of detailed…
ctrane
  • 61
  • 1
  • 7
2
votes
1 answer

Change Data Capture for several tables

SQL Server 2008. Is it possible to create Change Data Capture (or Change Tracking) for several related tabled in a db? For example many-to-many relation. How it will look like?
Anton Lyhin
  • 1,925
  • 2
  • 28
  • 34
2
votes
0 answers

Why are changesets missing from my Track Changeset view

I'm really hoping that someone is going to be able to help us out here... Imagine the following branch hierarchy: Main +--> Dev +--> Project 1 | | | +--> Project 2 | +--> Release 1 Now imagine that I have…
Antony Gibbs
  • 3,300
  • 1
  • 17
  • 12
1 2 3
…
23 24