DEWA-like Data Format Import Tool
This application can be used to migrade extracted data in DEWA-like format to a new database which is suitable for the Historian application.
Application migrates all KKS to new database. Only events occuring in specified time range are migrated to new database.
The application can be found at shared DropBox folder (Dropbox\99 - Inflex\Historian Versions\DEWA-like Format Migration).
- SourceConnection - connectionstring to the source database in DEWA-like format
- TargetConnection - connectionstring to the target database which should exist. If there are missing tables in the target database, the app will create them
- Start - migration time range start (in the format "yyyy-MM-dd HH:mm:ss.SSSS")
- End - migration time range end (in the format "yyyy-MM-dd HH:mm:ss.SSSS")
ConnectionString format is described here and typically contains following parameters:
- Server - server name
- Database - database name
- Uid - user login
- Pwd - password
Application Parameters Sample
-SourceConnection "Server=192.168.1.1;Database=DEWASource;Uid=inflex;Pwd=inflexHeslo;" -TargetConnection "Server=192.168.1.2;Database=DEWA;Uid=inflex;Pwd=inflexHeslo;" -Start "1970-01-01 00:00:00" -End "2020-3-31 23:59:59.9999"