i'm a newbie of Sql Data Generator, so perhaps my question is stupid. I'm using Sql Data Generator for filling a database using as source another one. A typical example of my actual job is:
- as table source i have the hotels and hotel_locations;
- as destination, i have two tables, hotels and hotel_details;
So i have for example to integrate data from source tables hotels and hotel_location and use them for fill the table hotels_details. Another example is that i have to copy the primary key from source table hotel to destination table hotels as primary key and hotels_details as foreign key
in a syncronized way.
For me it seems that Sql Data Generator isn't able to import data from multiple sources, instead it imports data from only one source at time. I'm right?