Move database to new server

[#1]

Hi.

We’re going to move a customer database to a new server. It’s approx. 14 GB. Is it necessary to perform an unload/reload at the same time? It’s been 2 years since the last time that was done.

Br,

Bjarne

[MarkCulp]

No need to rebuild. Just shutdown the database and copy the files to the new server.

[Former Member]

Thanks.

Just as I thought. Will consider an unload/reload if the performance does not increase significantly. But moving from an old 2008 server to a brand new 2016 server with SSD drives should do the trick.

Br,

Bjarne

[VolkerBarth]

If the hardware is very different, you might think about a re-calibration, aka ALTER DATABASE CALIBRATE...

[Former Member]

Ok, I'll check this out. Thanks.