﻿SQL2BT: Convert between SQL, BT, JSON
Usage: Sql2BT mode [/New:Yes|No] [/Child:Yes|No] [/CheckName:Yes|No] [/BTDir:dir] [/JsonDir:dir] [/DBC:dbName] [/DBP:dbName] [/DBCT:dbName] [/DBPT:dbName]
 Config file has the connection string and BT directory
 where mode:  0: (SQL2BT)   SQL  => BT,   can use options, /DBC:dbName /DBP:dbName
              1: (SQL2Json) SQL  => Json, can use options, /DBC:dbName /DBP:dbName
             10: (BT2SQL)   BT   => SQL,  can use options, /DBCT:dbName /DBPT:dbName
             11: (Json2SQL) Json => SQL,  can use options, /DBCT:dbName /DBPT:dbName");
            100: (ResetLink) Reset the links in content,  can use options, /DBCT:dbName /DBPT:dbName");
                      This output json files to the JSONX subdirectory
            200: (Json2BT)  Json => BT
            201: (BT2Json)  BT => Json
        [/ResetIDX:Yes|No]:  Reset the SQL Records IDX, default:Yes
        [/Child:Yes|No]:     process Child nodes, default: Yes
    [/CheckName:Yes|No]: Check by the Name(...) for uniqueness, default: No
                        * ResetIDX : suggest use No
    [/BTDir:BT dir]: direcotory of the BTree database
    [/JsonDir:Json dir]: direcctory of the Json files
    [/DBC:dbName]: source chineseMD db name, default: ChineseMD_SC
    [/DBP:dbName]: source chineseMD db name, default: PatientMD_SC
    [/DBCT:dbName]: target chineseMD db name, default: ChineseMD_SCx
    [/DBPT:dbName]: target chineseMD db name, default: PatientMD_SCx
   these default database names are specified in config file (dbConnection)
examples: Sql2BT 0
          Sql2BT SQL2BT
          Sql2BT 10
          Sql2BT SQL2BT /DBC:ChineseMD_SCx /DBP:PatientMD_SCx
          Sql2BT BT2SQL /ResetIDX:Yes /DBCT:ChineseMD_SCx /DBPT:PatientMD_SCx
          Sql2BT ResetLink /DBCT:ChineseMD_SCx /DBPT:PatientMD_SCx
   -------------------------------
          Sql2BT 1
          Sql2BT SQL2Json
          Sql2BT 11
          Sql2BT Json2SQL /ResetIDX:No
