delete data from inventTrans table on sandbox

(0) Share

Report

Posted on by VRD

Hi All,

Every month we create new products and we don't use older products for any new transactions in the future.

InventTrans table has grown to 30GB in size and we want to delete the data from it on our staging environment. It's our top most table in terms of size.

We want to delete data directly from SQL server if possible.

What is the best way to go for it?

Appreciate your help. Thanks.

Regards,

Vikky

I have the same question (0)

All responses (5)

Answers (1)

huijij 19,811 on at

Like (0)

Report

Hi Vikky,

Is it a Tier1 environment?

Was this reply helpful? Yes No
Suggested answer

Sheikh Sohail 6,125 on at

Like (0)

Report

Hi

You can connect any database except the production once and can delete the data directly from SQL.

Important

If you don't care about any circumstances in the staging environment, only then you can delete the data.

Was this reply helpful? Yes No
VRD on at

Like (0)

Report

Hi Soahil and Judy,

Thanks for your response.

Please note that I have access to SQL in the environment where we want to delete the data.

My concern is what is the best way to delete data from InventTrans. Do I need to take care of deleting data from any related table or just deleting straight away from InventTrans table should be suffice?

I will obviously want to delete the inventory transaction which are for older items that are no longer in use.

You can assume this environment as developer's box.

regards,

Vikky.

Was this reply helpful? Yes No
Suggested answer

Sheikh Sohail 6,125 on at

Like (0)

Report

Hi Vikky

It depends on your situation, if you don't work or open the old invoices or posted journal then you can directly truncate the tables.

if you don't delete the data from the reference table, then it will only make an impact on reports and reference fields.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (1)

Report

Hi Vikky,

I do assume you want to delete the data only from a staging/UAT environment, but not production. To ensure data consistency, you can also use a new feature for archiving inventory transactions. Then delete the archived inventory transactions (InventTransArchive).

You can read more about this new feature on my blog: Feature trial: Inventory transactions archive - Dynamicspedia

Was this reply helpful? Yes No