First use the following query on Portal 3's database to get the site_id and unit_id for the home:
SELECT st.name AS "Site Name",
st.id AS "careportal3_site_id",
un.id AS "careportal3_unit_id",
un.name AS "Unit Name"
FROM sites st
JOIN units un ON un.site_id = st.id
;
IF you want to filter the home specifically, then add the following line on the end (in this example the home is called "My Carehome"
WHERE st.name LIKE '%My Carehome%'
Once you have the ID's use the following query in Careportal 2 database to input the details
SELECT
id, home_name, dated, careportal3_site_id, careportal3_unit_id, roster_system, vroster_reports
FROM home_details
WHERE home_name LIKE '%My Carehome%'
;
In the resulting table:
1) paste in the unit id and the site id
2) change the roster_reports field to 1
3) enter "careportal3" into the roster_system field.