TARGIT InMemory Query Tool (tiQuery) can be used to execute SQL syntax against an TARGIT InMemory Database and see the results in a grid. It has a tree structure that allows you to view databases, tables and field names.
To run, execute tiQuery.exe in the Program Files\TARGIT InMemoryDB folder (double-click, or via command prompt). tiQuery can connect to a local or remote TARGITDB datasource.
To view a database in tiQuery, there are two methods:
- "Open" allows you to choose a particular .TARGITDB file, thus opening that database only.
- "Open (Lazy Load)" to enable on demand loading of tables. Table contents are brought into memory only as needed/ selected. This may prove a quicker/ less consuming way to open a large database on a system with limited resources.
- "Connect" allows you to view any database available to a particular TARGIT InMemory Database Server.
By selecting Connect, you can enter the servername (including path/ ip address if necessary), username and password.
After "Connecting", you can select which database you are currently querying via the Database dropdown at the top of the screen.
Note: there is no need to select a Database if you have selected "Open", since only one database will be available to tiQuery.