2 ms·
Yes, they can do similar things. However, there are several cases which you cannot handle automatically, due to incomplete information: - The current schema ha
by kokx 7y ago
Yes, they can do similar things. However, there are several cases which you cannot handle automatically, due to incomplete information:
- The current schema has a column A and the new version does not have A but a similar column B. Is this a new column? Or should A be renamed into B? (same for renaming tables)
- You add a new table A which contains columns from B, which are also removed from B. Should this data be copied?
- You change the structure of a table, and have some of it split off into different tables. How does the schema tool know how to rearrange the current data?
There are probably some more cases, but these are the ones I could think of quickly.