Copy Data from Two different databases with FK relation
0
votes
1
answer
209
views
So the situation is as follow:
I have **production DB** called **DB1** which has huge data, around 250 GB.
I have **Test DB** called **DB2** on my local machine which has the same schema as the production DB but only the first two tables are partially filled(**UUT_RESULT, STEP_RESULT**).
What I want:
Copy the only related data from the Production DB tables (**PROP_RESULT**) to my local DB table.
Very important note: I can copy the entire table, However, it's huge. That's why I only want to copy the data from **PROP_RESULT** table in the production DB which has relation to the already existed data in my local DB.
Note: Only UUT_RESULT and STEP_RESULT are partially filled in the Local DB, other tables are empty and I need to populate them and that's why I am posting this.
The following image will make is easier to understand

Asked by Nano
(139 rep)
Jul 17, 2019, 01:51 PM
Last activity: Jun 18, 2025, 03:02 PM
Last activity: Jun 18, 2025, 03:02 PM