I am using SAP B1 HANA as suggested by our implementation partner. Another consultant told me in B1 HANA there is no option to archive data hence the size of the database will keep getting larger and resource hungry. Is it true?
Secondly, can I now switch to SQL database from HANA? What would be the pros and cons of it? Coz the cloud for HANA is too expensive