Sample Header Ad - 728x90

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 enter image description here
Asked by Nano (139 rep)
Jul 17, 2019, 01:51 PM
Last activity: Jun 18, 2025, 03:02 PM