Share
Report
50What is the best methods to decrease the size of the below tables without any impact on the data upgrade process From AX2012 to D365FO or any impact on tables relation with other tables ?
Note : I will use standard Clean Up tools , but it doesn't include other mentioned tables and I know some of the below tables are for financial transactions and reconcile between modules , but we are trying to decrease downtime for data Upgrade process as much as possible , it took more than 9 days
| Table Name | SIZE (MB) |
| dbo.GENERALJOURNALACCOUNTENTRY | 78,930.04 |
| dbo.LEDGERJOURNALTRANS | 34,436.44 |
| dbo.ACCOUNTINGDISTRIBUTION | 21,527.49 |
| dbo.PROJTRANSPOSTING | 16,827.71 |
| dbo.SOURCEDOCUMENTLINE | 13,796.07 |
| dbo.SUBLEDGERJOURNALACCOUNTENTRY | 12,883.99 |
| dbo.PROJCOSTTRANS | 11,426.30 |
| dbo.GENERALJOURNALENTRY | 10,061.39 |
| dbo.PAYROLLPAYSTATEMENTLINE | 10,117.84 |
| dbo.SYSWORKFLOWINSTANCETABLE | 10,427.99 |
| dbo.SUBLEDGERJOURNALACCOUNTENTRYDISTRIBUTION | 8,216.62 |
| dbo.WORKFLOWTRACKINGTABLE | 4,643.79 |
| dbo.VENDSETTLEMENT | 4,457.34 |
| dbo.HCMPERSONIMAGE | 4,875.90 |
| dbo.VENDTRANS | 4,311.30 |
| dbo.LEDGERJOURNALTRANS_PROJECT | 4,108.13 |
| dbo.PAYROLLEARNINGSTATEMENTLINE | 4,238.02 |
| dbo.SUBLEDGERVOUCHERGENERALJOURNALENTRY | 3,468.62 |
| dbo.CUSTSETTLEMENT | 3,657.07 |
| dbo.WORKFLOWTRACKINGARGUMENTTABLE | 3,394.97 |
| dbo.CUSTTRANS | 3,401.08 |
| dbo.BANKACCOUNTTRANS | 3,281.36 |
| dbo.TAXTRANS | 2,689.33 |
| dbo.WORKFLOWTRACKINGCOMMENTTABLE | 2,543.32 |
| dbo.DOCUVALUE | 2,423.95 |
| dbo.PROJCOSTTRANSCOST | 2,410.79 |
| dbo.PROJCOSTTRANSSALE | 2,375.20 |
Categories:
All responses (
Answers (
