250k message 50Gb hMailServer migration
Posted: 2015-03-25 12:00
Hi everyone:
I am old user of hMailserver, our installation of hMailserver has survived around 10 years without any serious problem, and has iterated over a wide range of versions, I have moved message directory to a new HD when the original became too small, and everything went fine over those years thanks to hMailserver being a great tool and reading thorough this forum.
But today I am facing a transition I am not sure in a couple of steps. I am migrating hMailserver from the old and rusty server to a brand new one, everything is setup and only hMailserver rests to be moved.
I've already read a lot and have arrived to this conclusion:
I have 250k messages and 50Gb, so I cannot use the internal backup tool (at least is is not recommended).
The old server was using the default MySQL installation of the ancient versions, and the new one has a MSSQL 2014 Express installed because we need it for our CRM.
I have already copied and sinced all message data (50Gb) to the new server with a similar to Robocopy tool (FileSync very useful).
I don't know how to translate MySQL to MSSQL without hMailserver internal tool.
What do you think it is a better aproach ?
Is it reasonable to install a MySQL only for hMailserver and a couple of small web databases ?
In any case, can anyone explain a procedure to move such installation ?
Best regards to anyone that reads this
PD: Never in those 10 year hMailserver faulted, main issues were CLAMD dying a lot of years ago
Of course we don't want to change anything 
I am old user of hMailserver, our installation of hMailserver has survived around 10 years without any serious problem, and has iterated over a wide range of versions, I have moved message directory to a new HD when the original became too small, and everything went fine over those years thanks to hMailserver being a great tool and reading thorough this forum.
But today I am facing a transition I am not sure in a couple of steps. I am migrating hMailserver from the old and rusty server to a brand new one, everything is setup and only hMailserver rests to be moved.
I've already read a lot and have arrived to this conclusion:
I have 250k messages and 50Gb, so I cannot use the internal backup tool (at least is is not recommended).
The old server was using the default MySQL installation of the ancient versions, and the new one has a MSSQL 2014 Express installed because we need it for our CRM.
I have already copied and sinced all message data (50Gb) to the new server with a similar to Robocopy tool (FileSync very useful).
I don't know how to translate MySQL to MSSQL without hMailserver internal tool.
What do you think it is a better aproach ?
Is it reasonable to install a MySQL only for hMailserver and a couple of small web databases ?
In any case, can anyone explain a procedure to move such installation ?
Best regards to anyone that reads this

PD: Never in those 10 year hMailserver faulted, main issues were CLAMD dying a lot of years ago

