Adding new data type to live DB

I would like to add one new data type to the live DB, but the app restricts changes to dev DB only. I do not want to copy the whole dev DB to live DB because they have different content which I want to remain different. Is there a solution to this?

Hi there, @guy.pavlov84… I did exactly what you are describing in one of my live apps. When you are ready to add the new data type to the live db, you will simply deploy your current development version to live (which puts the data type out there but without any data in it). Then, to get the data into the new data type in the live db, use the Copy and restore database feature, and copy only the new data type you just added.

It goes without saying to take precautions and be super careful because you are messing with the live db, but I will say it anyway… take precautions and be super careful because you are messing with the live db. :slight_smile:

Hope this helps.

Best…
Mike

Thanks @mikeloc, it worked for me!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.