Product Home
DTM Data Generator Online Documentation Prev Page Prev Page
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Project Properties
Program Settings
General
Interface
Rule and project
Execution
Date and Time Formats
Execution
Random BLOB Loader
Project migration
Database Model Viewer
Fill Table Rule
Table Fill Modes
Table Fill Options
Tables options
Columns options
Row count tab
Scripts
Rule Output
Preview
Fill Methods
Method Options
Random values
Values list
From table
List from file
From Values Library
Incremental
By pattern
By SQL statement
By formula
Custom generator
Named Generators
Field groups
Advanced Rules
Clear Rule
Tables Creation Options
Objects Creation
File Rule
Advanced Features
Tables Selection
Bulk project modification
Table Information
Value Library
Change target Table
Command Line
Performance Tips
Performance mode
Format Strings
Select column
Data export
How to...
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Trademark Information
Glossary

Random BLOB loader

The Large Object Loader utility allows you to update selected column of the database table by random BLOBs from disk files located in the specified directory. Warning: all existing BLOBs will be overwritten without prompting.
The main purpose of the utility is loading objects to the existing table, for which DTM Data Generator has already generated data. The utility randomly selects files from the folder specified by the user, using them as objects.

The utility uses current database connection provided by the data generator. You should select a table and a field where the data will be loaded. If the table has a primary key, the program uses it automatically. If it doesn't, you should manually specify fields by which the program will search for unique records for loading. Be attentive when you select them.
The utility can load values both to all available records and to several records from the beginning of the table, if the corresponding parameter is specified. If you need to load data to more than one field, you should start the process several times, changing the field name and probably the folder with source files.

DTM Data Generator: large object loader utility