go to post Luc Morningstar · Jun 18, 2022 Just by curiosity I tried it on Caché>>> Cache for Windows (x86-64) 2018.1.3 (Build 414U) <<< As ZPM is missing I had to use the manual installationFollowing strictly the installation guide It got up and running immediately It fully fills all my needs from any of my browsers.
go to post Luc Morningstar · Mar 16, 2022 in Caché $system.SQL.Export() writes all DDL to file adjustment for MS SQL might be required. next you loop in a routine with SELECT * from ....<your tables> and write it to external filesthe appropriate methods are in %SQL.Statement.
go to post Luc Morningstar · Sep 19, 2021 what is the size of your DBs? ref: ERROR #94: Total size of all databases would exceed the licensed amount. just gives a reason. could be there are parts you don't need at all.you talk about ROUTINES - > 10GB of routine sounds rather unrealistic.So splitting routines from globals might be a useful exercise.In addition the size of Db does say nothing of the size of the content. some GBLOCKCOPY may help to shrink the DB.And as you write Cache.DAT why not do it on Caché if you did this before ?