DMS automatic migrations #455
gentledepp
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I am sorry for starting a discussion around this, but I cannot find the issue anymore where we discussed this topic.
I am trying to wrap my head around schema migrations.
Principally there are always two ways to handle migrations:
All clients always migrate their schema automatically along with the server and re-synchronize the changed tables to get the values of any new column
Clients keep their schema until changed by the developer. That way, old clients (without schema changes) would still have to be able to synchronize with the server that already runs the latest schema.
Let's say:
Product
with several columnsProductId, Name, Description
Price
nullable
of course!Price
column and sync it.How am I supposed to do that?
I wish I could:
Price
columnPrice
column does not exist on the client side and add that column (Alter table Product add column Price double null
or something like that)Price
column, to do a re-initialize sync of that one table.One more important topic: Is there also the possibility for old clients to not update their local schema and still being able to sync?
There would be only one important thing to achieve:
Price
column nor its data, the changes they send to the server will not contain any value forPrice
null
to any updatedProduct
row, thus, leading to data loss.Is that possible at all?
Please link the original discussion/issue if you still find it! Thanks!
Beta Was this translation helpful? Give feedback.
All reactions