tiImport is a command line utility used to import data into TARGIT InMemory Database (build a database). The tiImport.exe takes one main parameter which is the name of the import file to read in
e.g. From the command line, typetiImport northwind.imp This executes an import file called northwind.imp and stores the data as northwind.targitdb in the same folder.Additional parameters can be referenced as variables inside the script. Note 1: If you would like to run the example imports (supplied with TARGIT InMemory Database) based on the Northwind database, ensure you have a Northwind database available. –e.g. MS Access file "northwind.mdb" can be downloaded from multiple sources. Next create a data connection to this source. –e.g. 32bit or 64bit ODBC driver, called "targit_northwind" (as used in northwind.imp), pointing to this database. Note 2: You can edit northwind.imp with a text editor to see what it is doing.
In this case, assuming TARGIT InMemory Database was installed to c:\program files\TARGIT\TARGIT InMemoryDB you can run this import file by opening a command prompt, going to the C:\ProgramData\TARGIT\TARGIT InMemoryDB\ data folder, then entering:
"c:\program files\targit\TARGIT InMemoryDB\tiImport" "c:\programdata\targit\TARGIT InMemoryDB\data\northwind.imp"
This calls on tiImport.exe to run the .imp file. Note 3: .imp is the standard extension for TARGIT InMemory import scripts. It generates a .targitdb data file of the same name in the same directory. Note 4: tiImport.exe runs in 64bit mode in a 64bit environment and in 32bit mode in a 32bit environment. To connect to a 32bit data-source (e.g. 32bit ODBC) whilst running in a 64bit environment, tiImport32.exe should be used instead. tiImport32 does exactly the same as tiImport but will always run in 32 bit mode. This can be necessary if e.g. connection using a Dynamics NAV Native driver that only is deliver as 32bit. To reload an update data file on the server, use tiLoad with the /reload parameter.

  • No labels