topic Re: Migrate existing Metastore to a new Metastore in same region in Data Governance

Migrate existing Metastore to a new Metastore in same region

Yulei — Mon, 29 Jan 2024 07:43:58 GMT

Hi, Databricks Community

I am currently plan to do migrate of existing metastore (not in a desired account and name) to a new one (a different desired account) within the same region. I understand it is not as straightforward it might be and complicated.

Can I ask, what might be the best approach to actually fulfil this?
What could be the issue if Metastore and the S3 bucket is set up on different region?
We have set up external tables and connects with existing Metastore, would we lose tehm once we move to the new one?
Can we set up a sync between the new and existing Metastore and S3 bucket, what impact could that lead to?
is there anything that we need to concern about this idea?

Re: Migrate existing Metastore to a new Metastore in same region

jose_gonzalez — Wed, 31 Jan 2024 19:24:02 GMT

Hi @Yulei,

Please follow Kaniz's recommendations. If you still have questions or issues, then lets us know and we will gladly help you to resolve this issue

Re: Migrate existing Metastore to a new Metastore in same region

Yulei — Thu, 01 Feb 2024 01:16:15 GMT

hi, @Retired_mod . Thank for the recommendations and links, they are helpful and I am going through them one by one.

Re: Migrate existing Metastore to a new Metastore in same region

zmsoft — Wed, 25 Jun 2025 01:57:35 GMT

Hi team,

I can't see Kaniz's recommendations. Are there any related links in this topic?

Thanks&Regards,

zmsoft