Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Valid destination database connection parameters are specified in the command line
  2. The source file (result of export) and an optional configuration .INI file are specified in the command line
  3. CastDBTransfert.exe is executed via the command line
  4. Access to the destination database is locked to ensure a smooth transfer
  5. Any data in the destination database is deleted (except CAST Enlighten Graphical Views when the -NoMergeViews parameter is omitted)
  6. Data from source file (result of export) is imported into the destination database

Export command line

OptionPossibilityExampleNotes
-DATABASEORACLE | SQLSERVER | CastStorageService-DATABASE(<DATABASE_TYPE>)Requires -CONNECT
-CONNECTN/A-CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,
<CENTRAL_SITE_NAME>)
Requires -DATABASE
-EXPORT_CENTRALN/A-EXPORT_CENTRAL(<path and name of destination file>, [<path and name of configuration .INI file>])The name and path of the configuration .INI file is optional
-EXPORT_LOCALN/A-EXPORT_LOCAL(<path and name of destination file>, [<path and name of configuration .INI file>])The name and path of the configuration .INI file is optional
-LOGN/A-LOG(<path and name of export log file>)The name and path of the export log file is optional

Therefore:

  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<CENTRAL_SITE_NAME>) -EXPORT_CENTRAL(E:\tmp\ExpImp\output.dat)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<CENTRAL_SITE_NAME>) -EXPORT_CENTRAL(E:\tmp\ExpImp\output.dat) -LOG(E:\tmp\ExpImp\export_central)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<CENTRAL_SITE_NAME>) -EXPORT_CENTRAL(E:\tmp\ExpImp\output.dat, E:\tmp\ExpImp\export_central.ini)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<LOCAL_SITE_NAME>) -EXPORT_LOCAL(E:\tmp\ExpImp\output.dat)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<LOCAL_SITE_NAME>) -EXPORT_LOCAL(E:\tmp\ExpImp\output.dat) -LOG(E:\tmp\ExpImp\export_local)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<LOCAL_SITE_NAME>) -EXPORT_LOCAL(E:\tmp\ExpImp\output.dat, E:\tmp\ExpImp\export_local.ini)

 


Info
  • The name and path of the destination file is obligatory - you can also (optionally) use a configuration .INI file to specify the location
  • The .DAT extension is used for example purposes. You can use any extension (.TXT, .DAT, .DMP etc.)
  • Please make sure you surround the path and file name (for both the data file and the .INI file) with single quote marks if the path contains spaces, for example: –EXPORT_CENTRAL('C:\temporary files\output.dat')
  • If the path to the CastDBTransfert.exe file is specified in the command line and it contains spaces, then please maker sure you use double quote marks, for example: "C:\Program Files\CAST\CastDBTransfert.exe"
  • If you omit an option (for example if your server does not require a password), please make sure you still include the comma: -CONNECT(WESLEY,sa,,CENTRAL_SITE)
  • LOCAL refers to a CAST Analysis Service
  • CENTRAL refers to a CAST Dashboard Service

...

No Format
"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(ORACLE) -CONNECT(CEMAES,system,manager,V71_CENTRAL) -EXPORT_CENTRAL(E:\tmp\output.dat)
 
"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(ORACLE) -CONNECT(CEMAES,system,manager,V71_CENTRAL) -EXPORT_CENTRAL(E:\tmp\output.dat) -LOG(E:\tmp\export_central)

"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(SQLSERVER) -CONNECT(NEFYN,sa,cast,V71_CENTRAL) -EXPORT_CENTRAL('E:\tmp\cast files\output.dat')

"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(CastStorageService) -CONNECT(CEMAES,operator,CastAIP,V71_CENTRAL) -EXPORT_CENTRAL(E:\tmp\output.dat)

"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(ORACLE) -CONNECT(CEMAES,system,manager,V71_LOCAL) -EXPORT_LOCAL(E:\tmp\output.dat)
 
"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(ORACLE) -CONNECT(CEMAES,system,manager,V71_LOCAL) -EXPORT_LOCAL(E:\tmp\output.dat) -LOG(E:\tmp\export_local)

"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(SQLSERVER) -CONNECT(NEFYN,sa,cast,V71_LOCAL) -EXPORT_LOCAL('E:\tmp\cast files\output.dat')

"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(CastStorageService) -CONNECT(CEMAES,operator,CastAIP,V71_LOCAL) -EXPORT_local(E:\tmp\output.dat)

Import command line

OptionPossibilityExampleNotes
-DATABASEORACLE | SQLSERVER | CastStorageService-DATABASE(<DATABASE_TYPE>)Requires -CONNECT
-CONNECTN/A-CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,
<CENTRAL_SITE_NAME>)
Requires -DATABASE
-IMPORT_CENTRALN/A-IMPORT_CENTRAL(<path and name of source file>, [<path and name of configuration .INI file>])
  • The name and path of the configuration .INI file is optional.
  • The source file refers to the file that was generated using the Export command line.
-IMPORT_LOCALN/A-IMPORT_LOCAL(<path and name of source file>, [<path and name of configuration .INI file>],[ -NoMergeView])
  • The name and path of the configuration .INI file is optional
  • For more information on –NoMergeView see the section below
  • The source file refers to the file that was generated using the Export command line.
-LOGN/A-LOG(<path and name of import log file>)The name and path of the import log file is optional

...


Therefore:

  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<CENTRAL_SITE_NAME>) -IMPORT_CENTRAL(E:\tmp\ExpImp\output.dat)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<CENTRAL_SITE_NAME>) -IMPORT_CENTRAL(E:\tmp\ExpImp\output.dat) -LOG(E:\tmp\ExpImp\import_central)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<CENTRAL_SITE_NAME>) -IMPORT_CENTRAL(E:\tmp\ExpImp\output.dat, E:\tmp\ExpImp\import_central.ini)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<LOCAL_SITE_NAME>) -IMPORT_LOCAL(E:\tmp\ExpImp\output.dat)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<LOCAL_SITE_NAME>) -IMPORT_LOCAL(E:\tmp\ExpImp\output.dat) -LOG(E:\tmp\ExpImp\import_local)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<LOCAL_SITE_NAME>) -IMPORT_LOCAL(E:\tmp\ExpImp\output.dat, E:\tmp\ExpImp\CopyKB.ini)
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<LOCAL_SITE_NAME>) -IMPORT_LOCAL(E:\tmp\ExpImp\output.dat, , -NoMergeView)
    -> imports a file into the target database without reconciling the CAST Enlighten views
  • CastDBTransfert.exe -DATABASE(<DATABASE_TYPE>) -CONNECT(<SERVER>,<USER_NAME>,<PASSWORD>,<LOCAL_SITE_NAME>) -IMPORT_LOCAL(E:\tmp\ExpImp\output.dat, E:\tmp\ExpImp\CopyKB.ini, -NoMergeView)
    -> imports a file into the target database without reconciling the CAST Enlighten views and uses a configuration .INI file to modify the file paths

...


Info
  • The name of the source file is obligatory - you can also use an (optional) configuration .INI file to specify the location
  • Please make sure you surround the path and file name (for both the data file and the .INI file) with single quote marks if the path contains spaces, for example: -IMPORT_CENTRAL('C:\temporary files\output.dat')
  • If the path to the CastDBTransfert.exe file is specified in the command line and it contains spaces, then please maker sure you use double quote marks, for example: "C:\Program Files\CAST\CastDBTransfert.exe"
  • If you omit an option (for example if your server does not require a password), please make sure you still include the comma: -CONNECT(WESLEY,sa,,CENTRAL_SITE), or -IMPORT_LOCAL(E:\tmp\ExpImp\output.dat, , -NoMergeView)
  • LOCAL refers to a CAST Analysis Service
  • CENTRAL refers to a CAST Dashboard Service

Examples

...


No Format
"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(ORACLE) -CONNECT(CEMAES,system,manager,V71_CENTRAL) -IMPORT_CENTRAL(E:\tmp\output.dat)
 
"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(ORACLE) -CONNECT(CEMAES,system,manager,V71_CENTRAL) -IMPORT_CENTRAL(E:\tmp\output.dat) -LOG(E:\tmp\import_central)

"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(SQLSERVER) -CONNECT(NEFYN,sa,cast,V71_CENTRAL) -IMPORT_CENTRAL('E:\tmp\cast files\output.dat')

"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(CastStorageService) -CONNECT(CEMAES,operator,CastAIP,V71_CENTRAL) -IMPORT_CENTRAL(E:\tmp\output.dat)

"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(ORACLE) -CONNECT(CEMAES,system,manager,V71_LOCAL) -IMPORT_LOCAL(E:\tmp\output.dat)
 
"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(ORACLE) -CONNECT(CEMAES,system,manager,V71_LOCAL) -IMPORT_LOCAL(E:\tmp\output.dat) -LOG(E:\tmp\import_local)

"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(SQLSERVER) -CONNECT(NEFYN,sa,cast,V71_LOCAL) -IMPORT_LOCAL('E:\tmp\cast files\output.dat')

"C:\Program Files\CAST\CastDBTransfert.exe" -DATABASE(CastStorageService) -CONNECT(CEMAES,operator,CastAIP,V71_LOCAL) -IMPORT_local(E:\tmp\output.dat)

...