Link to home
Start Free TrialLog in
Avatar of Maurìzio TERÙZZI
Maurìzio TERÙZZIFlag for Switzerland

asked on

Need help to Pervasive upgrade and LOG/DB split if possible

Hi, we plan to move our production Pervasive PSQL Database v11.20 to v15 ZEN PSQL.
Now the v11 is hosted by a MS SBS2011 and we will move out to a normal std windows 2022 server.

We have a DBA that will come on site in the next mounth to do the job, I need some advices.


My questions:
1 - know someone the DB migration path, our Licences is no more valid (2012) and we don't have access to the KB anymore. Just simple to know if we have to migrate the DB through most major versions (12, 13, 14 then 15) or other steps (as say an external DBA will come onsite) but I shall know about it.
2- in this type of DB PSQL it's possible to separate DB/LOG (temp tables) to enhance the performance? Our server architecture will have 2x R1 separated on SSD, with possibility to split on 2 physicals differents arrays.

Grazie
M.

ASKER CERTIFIED SOLUTION
Avatar of Bill Bach
Bill Bach
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial