How to free space from the Tenant Media table?

juliosistemas
Member Posts: 3
Hi, I have 20GB of information from the Tenant Media table, I need help on how to free up space on that table. I deleted the images of all the products from the Items table and they are still visible in that table, there are even images that had been removed a long time ago. I am using Dynamics NAV 2018.


0
Best Answer
-
The only way I know how to do this:
First you have to scan your database for used media type fields.
(This can be automated using recrefs, or just decide what fields are needed to be kept in tenant media)
Create a buffer table with only guid as primary key.
Insert all MediaId guids that are used from all tables and media fields you pinpointed in previous step.
F.i. while looping DocAtt:
if DocAtt."Document Reference ID".hasvalue then begin
UpgDocAttMediaId.Id := DocAtt."Document Reference ID".MediaId;
UpgDocAttMediaId.insert;
end;
The guids in UpgDocAttMediaId are the primary for
TenantMedia: Record "Tenant Media";
So finally, if not your TenantMedia is found in UpgDocAttMediaId,
TenantMedia can be deleted.
And theoretically, if no tenantmedia is found, the media field should be cleared.
When migrating to SaaS you do want to clean up this table before uploading it all.
Hopefully somebody here found a better way to do this, and is willing to share too🙂.
1
Answers
-
The only way I know how to do this:
First you have to scan your database for used media type fields.
(This can be automated using recrefs, or just decide what fields are needed to be kept in tenant media)
Create a buffer table with only guid as primary key.
Insert all MediaId guids that are used from all tables and media fields you pinpointed in previous step.
F.i. while looping DocAtt:
if DocAtt."Document Reference ID".hasvalue then begin
UpgDocAttMediaId.Id := DocAtt."Document Reference ID".MediaId;
UpgDocAttMediaId.insert;
end;
The guids in UpgDocAttMediaId are the primary for
TenantMedia: Record "Tenant Media";
So finally, if not your TenantMedia is found in UpgDocAttMediaId,
TenantMedia can be deleted.
And theoretically, if no tenantmedia is found, the media field should be cleared.
When migrating to SaaS you do want to clean up this table before uploading it all.
Hopefully somebody here found a better way to do this, and is willing to share too🙂.
1
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions