v2.0.5

• add SmartCode.ETL.LoadToES
• add SmartCode.ETL.LoadToES support ES_ID_Mapping
• fix CamelCaseConverter not work ,Thx #23

v2.0.0

1. optimize SmartCode.ETL.LoadTask by using DbSession
2. optimize the template directory structure
3. optimize IETLRepository -> IETLTaskRepository
4. add Java-Template
5. add SmartCode-Spring-Boot.yml
6. update SqlMap-Partials template
7. add SmartCode.ETL.LoadToES(ElasticSearch)
8. update dependent lib version

1.18.1

1. add support SmartCode.ETL.SQLite （ETL任务持久层新增支持SQLite，免去DB服务端安装！）

ETLRepository: SQLite

v1.16.19

1. support for SqlServer paging syntax By [Offset Fetch]
2. fix #19
3. fix #16
4. add ETL-DOC

• https://github.com/Ahoo-Wang/SmartCode/blob/master/doc/SmartCode.ETL.md
• https://github.com/Ahoo-Wang/SmartCode/blob/master/doc/SmartCode.ETL-EN.md

v1.16.15

1. add support ETLExtract.MaxModifyTime
2. add support Generator.Oracle ,thx #15
3. fix SqlServer.IsPrimaryKey bug

v1.16.12

1. fix Ignore system tables by is_ms_shipped
2. add SqlServerToPGBuild
3. add SqlServer to PostgreSql DataTypeMap
4. add DelimiterConverter
5. add SmartCode.ETL.PostgreSql
6. SmartCode-Gen-ETL

## SqlServer 迁移到 PG 构建配置生成器模板
Module: SqlServer2PG
Author: Ahoo Wang
DataSource:
  Name: DbTable
  Paramters:
    DbName: SqlServerDB
    DbProvider: SqlServer
    ConnectionString: Data Source=localhost;database=SqlServerDB;uid=SmartSql;pwd=SmartSql
Language: PostgreSql
TemplateEngine: Razor
Paramters:
  ExtractMode: QueryTime
  ModifyTime: ModifyTime
  ExtractConnectionString: Data Source=localhost;database=SqlServerDB;uid=SmartSql;pwd=SmartSql
  LoadDbProvider: PostgreSql
  LoadConnectionString: Server=localhost;Port=5432;User Id=report;Password=SmartSql;
Output: 
  Type: File
  Path: 'E:\ETL\SmartCode.ETL.Starter'

# 构建任务
Build:

  ClearDir:
    Type: Clear
    Paramters:
      Dirs: '.'
# 生成迁移SQL
  DbToPGSql:
    Type: Single
    Module: SmartCode
    Template: Sql/DbToPGSql.cshtml
    Output: 
      Path: '.'
      Name: 'Sql'
      Extension: '.sql'
    NamingConverter:
      Table:
        Tokenizer: 
          Type: Default
          Paramters: 
            IgnorePrefix: 'T_'
            Delimiter: '_'
            UppercaseSplit: true
        Converter:
          Type: Delimiter
          Paramters: 
            Delimiter: '_'
            Mode: AllLower
            Prefix: t_

      Column:
        Tokenizer: 
          Type: Default
          Paramters: 
            Delimiter: '_'
            UppercaseSplit: true
        Converter:
          Type: Delimiter
          Paramters: 
            Delimiter: '_'
            Mode: AllLower
# 生成 SmartCode.ETL 数据迁移构建配置
  ToPGBuild:
    Type: Table
    Module: SmartCode
    Template: ETL/ToPGBuild.cshtml
    Output: 
      Path: '.'
      Name: '{{Items.CurrentTable.Name}}'
      Extension: '.yml'
    NamingConverter:
      Table:
        Tokenizer: 
          Type: Default
          Paramters: 
            IgnorePrefix: 'T_'
            Delimiter: '_'
            UppercaseSplit: true
        Converter:
          Type: Delimiter
          Paramters: 
            Delimiter: '_'
            Mode: AllLower
            Prefix: t_
      Column:
        Tokenizer: 
          Type: Default
          Paramters: 
            Delimiter: '_'
            UppercaseSplit: true
        Converter:
          Type: Delimiter
          Paramters: 
            Delimiter: '_'
            Mode: AllLower

v1.16.0

1. add SmartCode.ETL
2. add SmartCode.ETL.PostgreSql

Author: Ahoo Wang
DataSource:
  Name: Extract
  Paramters:
    DbProvider: SqlServer
    ConnectionString: Data Source=.;Initial Catalog=SmartSqlDB;Integrated Security=True
    Query: SELECT [Id],[UserName],[Pwd],[Status],[LastLoginTime],[CreationTime],[Deleted] FROM [T_User] Where Id>@LastMaxId And CreationTime>@LastQueryTime
    PKColumn: Id

Paramters:
  ETLCode: SmartCode.ETL.Test
  ETLRepository: PG
  
Build:

  Transform:
    Type: Transform
    Paramters:
      Script: Load2PostgreSql.cshtml

  Load2PostgreSql: 
    Type: Load
    Paramters:
      DbProvider: PostgreSql
      ConnectionString: Server=localhost;Port=5432;User Id=postgres;Password=SmartSql; Database=smartsql_db;
      Table: t_user
      ColumnMapping: [{Column: UserName,Mapping: user_name}
      ,{Column: Pwd,Mapping: pwd}
      ,{Column: Status,Mapping: status}
      ,{Column: LastLoginTime,Mapping: lastlogintime}
      ,{Column: CreationTime,Mapping: creationtime}
      ,{Column: Deleted,Mapping: deleted}]
      PreCommand: 
      PostCommand: 
      

v1.8.0

1. add ProcessBuildTask
2. support SQLite
3. fix 中文表名输出文件名乱码
4. add Output.Mode:Incre/Full,default Incre
5. u SmartSql version to templates
6. optimize log output

v1.6.8

1. add 仅需配置好数据链接，直接构建整个解决方案，运行API项目进行Swagger调试！！！

---

1. add just needs to configure the ConnectionString, directly build the whole solution, run the API project for Swagger debugging!!!

v1.5.0

1. remove RazorLight TemplateEngine !!!