After an unsuccessful migration a couple of months back I tried again.
I went with a global install of ghost-cli (using npm v5.3.0) and followed the instructions for migrating to v1.0.0.
The recommended setup is linux, I'm running a Windows Home Server, there are a few prompts which you can skip through.
I did have a local mysql install but the Ghost installer was able to create a user but not able to create the database. Once I created it manually I was able to run
ghost setup and the database migrations ran successfully.
You can skip pass the systemd prompt I used NSSM instead to start and manage the node process. Things to note here are setting the working directory (AppDirectory) to the root of your install folder. The script to run should be