The Update Data Generator generates Update SQL statements. The generated statements can be executed directly on your target database , or the generated SQL can be saved to file to be executed later on a database and platform of your choice.
The following example shows Update SQL statements for a Microsoft Jet database setting the Customer table to a random Street value:
update [Customer]
set [Street] = 'Port Close'
where [Id1] = 1
update [Customer]
set [Street] = 'Lenfield Avenue'
where [Id1] = 2
update [Customer]
set [Street] = 'Maple Avenue'
where [Id1] = 3
update [Customer]
set [Street] = 'Edinburgh Square'where [Id1] = 4
Figure 0.1 Example Update SQL statements generated by TurboData
See TurboData Scenarios Overview
