Move rows from one table to another liquibase

sticky_elbows 0
Viewed 11

I need to drop one table, but before I need to move all the data that is in that table to another table with xml liquibase. I tried with update but it is giving ORA-00936: missing expression. Can someone help please ? What is the syntax / correct way to migrate one table to another row by row ?

Than k you.

liquibase-sql liquibase-hibernate liquibase xml
1 Answers

What about sqlChange with insert from source table? Here is the fiddle to test. Note it could take a lot of time if table is too big.

<changeSet id="id" author="you">
    <sql>insert into target_table select * from source_table</sql>
</changeSet>
bilak0
Related