Hi

I've been tasked with migrating a clients site from one hosting environment to another. The site is currently 7.0.4 and I hope to also upgrade it to the latest version.

They're currently with a hoster that have a control panel whereby you can run a script out the database and content.

However, when I run the script locally, I'm getting a lot of errors with regard to creating foreign keys on tables. I've had a look round and it appears this is common with the Umbraco DB. So, I've asked the client if they can get hold of a .bak file to restore from but this might not be possible.

Any suggestions on how I could get around this? From what I can see my options would be:

1. Ignore the errors with regards to keys - will the site and CMS still run fine if it doesn't have them?

2. Try and fix the issues withe the FKs - however I'm always nervous of touching the Umbraco DB directly

3. Any thing else I could do?

Thanks in advance