Pages

Wednesday, August 9, 2017

Database log changes in Update 8

Update 8 changes how the database log is logging changes to data. Before Update 8 this was handled through triggers in the kernel and then some application code.

In Update 8 this now happens on triggers created on the SQL Database for each table you enable logging on.

You can still find the old application code in Update 8, but it is not triggered anymore.

There is a bit more information on this community thread: https://community.dynamics.com/ax/f/33/p/246718/684546#684546

2 comments:

Mötz Jensen said...

Hi!

Any ideas on how they handle rename of a table or column, that have a trigger enabled?

Best Regards
Mötz Jensen

Palle Agermark said...

Hi Mötz,

Renaming tables or columns is not supported at all (yet). Since there no longer are any ids in the metadata, a rename today will mean that the table or column having the old name will be dropped from the database and you'll loose data.

Best regards
Palle