Restoring a Database on a new server with the SAME domain

Matthew Neal asked on October 19, 2017 07:52

Hi all, I have a pretty simple question that I hope someone can answer quickly.

I had a developer migrate our site to a new server, and we've moved the DNS over to the new one, and everything is going great. However, he's used a backup of the database from a week ago, and there's hours and hours worth of content on the old server. I've backed up the old server, and I'm ready to add the latest backup of the database, BUT...

When migrating to a new server, do I physically need to change anything in any of the tables? For example, if I just upload this database from the old server to the new one, am I gonna break something?

Unfortunately my dev is away on holidays for another week and I kinda need to do this today :(

Thanks so much for your help!

database migration kentico 9

Correct Answer

Matt Nield answered on October 19, 2017 08:06

From what I can see above, I think you should be fine. The Kentico BD does not contain any DNS settings. There could be custom work that I’m not going to be aware of and that does add some risk.

If your developer has changed the location that files are stored, then this may also cause an issue. There is a table called CMS_SettingsKeys that would contain these setting if that has been done.

I’m assuming the website domain is the same on both sites, but if not you may need to look at the Sites application, and maybe licenses too:

https://docs.kentico.com/k9/configuring-kentico/managing-sites/setting-domain-names-for-sites
https://docs.kentico.com/k9/configuring-kentico/managing-sites/managing-site-licenses

I can’t think of anything else off the top of my head. If you can contact your developer though to double check, I’d recommend doing that. I know I’d rather get a call about something like this that potentially have to come back after a holiday to fix any issues.

1 votesVote for this answer Unmark Correct answer

Recent Answers

Matthew Neal answered on October 19, 2017 08:14 (last edited on October 19, 2017 08:14)

Excellent, thank you. Instead of just overwriting the database my dev added, I created a new one with the backup and changed the config file. After clearing the cache, it appears to be working perfectly.

Thanks so much!!!

Edit: Your name is oddly close to mine lol.

0 votesVote for this answer Mark as a Correct answer