DB migration2

• 

  DataBase Migration Tip! DDL 변경해 주는 사이트 www.sqlines.com/online SQLines - Online SQL Conversion - SQL Scripts, DDL, Queries, Views, Stored Procedures, Triggers, Embedded SQL -- Please use the desktop version to convert large SQL scripts, -- or if there are any issues with Online conversion. -- Feel free to contact us at support@sqlines.com www.sqlines.com 사이트에 들어가면 아래와 같은 화면이 나오는데 Source : 현재 사용중인 DataBase Target : 이관할 DataBase 를 각각 선택.. 웹개발/TIL 2021. 5. 11.

• Oracle to PostgreSQL Migration MERGE INTO 구문 변경 oracle MERGE INTO COMTNAUTHORINFO USING DUAL ON (AUTHOR_CODE = 'ROL_TEST1') WHEN MATCHED THEN UPDATE SET AUTHOR_NM = '테스트권한' ,AUTHOR_DC = '테스트권한' ,AUTHOR_CREAT_DE = '2020-09-01' WHEN NOT MATCHED THEN INSERT (AUTHOR_CODE, AUTHOR_NM, AUTHOR_DC, AUTHOR_CREAT_DE) VALUES ('ROL_TEST', '테스트권한1', '테스트권한1', SYSDATE); postgres WITH UPSERT AS( UPDATE comtnauthorinfo SET author_nm = '테스트권한' ,author_dc = '테스.. DataBase/PostgreSQL 2021. 4. 29.