Has anyone migrated a Vertica DB to a new storage area before?
We want to move our Vertica database which is currently stored on a VM to our SAN, but I can't appear to find any documentation about migrating a db from one storage area to another. I've followed up this with our account manager, and haven't had much luck finding documentation. The db server itself is to remain intact, it's just the data files we want to move. As I'm new to Vertica (and indeed have been out of the industry for a while so have rusty db admin skills), the only parallel I can draw from memory is that in SQL Server, you can unmount the db, move it, and then remount it. I can only presume there is something similar in Vertica, but can't find how to do this. Any help would be greatly appreciated. Thanks Ben