Finance | Project Operations, Human Resources, ...

Multi-Company Database Separation

(0) Share

Report

Posted on by SL_GP_BC_123

987

We have a site on Dynamics SL 2018. They use Multi-Company and have 4 companies in a Single database. Two companies were sold off earlier this year and the remaining two are being transferred to new ownership. That said, is it possible to purge history for individual companies within a multi-company configuration. We'd like to purge history for the two companies that were sold, while retaining history for the other two.

Please advise. Look forward to a reply. Thank you.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Mark E 6,451 on at

Like (1)

Report

I did this recently for a very similar situation. Wound up writing a long series of SQL scripts that deleted records from any table that had a reference to the CpnyIDs that needed to be purged, along with some other records with indirect relationships to those companies. Took multiple rounds of testing, but in the end was very successful.

Was this reply helpful? Yes No
SL_GP_BC_123 987 on at

Like (0)

Report

I've been playing with the test company and figured the same. Just going to take a fair amount of testing.

Appreciate the feedback.

JG

Was this reply helpful? Yes No