Hi there,
At our company we had to recently change database instance. All tables and columns are the same.
We are wondering if we can simply go to Databases inside Metabase and change the host.
Will this affect our Questions? We don't want to lose everything we've built.
Hi @lucascastellani
Yes, you can simply change the settings in Admin > Database > (your-db), so it connects to your new database.
As long as there's no difference in schema/table/column structure, then everything will keep working.
That is how many switches between staging and production databases.
If there are differences in structure, then it will require a lot more work.
But as with any big change, make sure you have backups first.
Thanks, worked.