SQL2DB 사용자 매뉴얼

<migration name="사용자_이관" use="true">
  <source db="sourceDB">
    <![CDATA[
      SELECT UserID, UserName, Email, CreatedDate, Status
      FROM Users 
      WHERE Status = 'Active'
    ]]>
  </source>
  
  <target db="targetDB" table="Users">
    <columns>
      <column name="UserID" type="int" />
      <column name="UserName" type="varchar(100)" />
      <column name="Email" type="varchar(255)" />
      <column name="CreatedDate" type="datetime" />
      <column name="Status" type="varchar(20)" />
      <column name="MigratedDate" type="datetime" override="true">${currentDate.CurrentDate}</column>
    </columns>
  </target>
</migration>

<dynamicVars>
  <dynamicVar name="lastSyncDate">
    <![CDATA[
      SELECT MAX(LastModifiedDate) as LastSyncDate 
      FROM TargetDB.dbo.Products
    ]]>
  </dynamicVar>
</dynamicVars>

<migration name="제품_이관">
  <source db="sourceDB">
    <![CDATA[
      SELECT ProductID, ProductName, Price, LastModifiedDate
      FROM Products 
      WHERE LastModifiedDate > ${lastSyncDate.LastSyncDate}
    ]]>
  </source>
</migration>

<migration name="주문_이관">
  <!-- 전처리: 기존 데이터 정리 -->
  <preProcess db="targetDB">
    <![CDATA[
      DELETE FROM Orders WHERE OrderDate >= '2024-01-01'
    ]]>
  </preProcess>
  
  <source db="sourceDB">
    <![CDATA[SELECT * FROM Orders WHERE OrderDate >= '2024-01-01']]>
  </source>
  
  <target db="targetDB" table="Orders" />
  
  <!-- 후처리: 인덱스 재생성 및 통계 업데이트 -->
  <postProcess db="targetDB">
    <![CDATA[
      CREATE INDEX IX_Orders_OrderDate ON Orders(OrderDate)
      UPDATE STATISTICS Orders
    ]]>
  </postProcess>
</migration>