 FROM cananolab.instrument_config
 ;
 
-/*
-INSERT INTO canano.derived_bioassay_data
-(
-	derived_bioassay_data_pk_id,
-	characterization_pk_id,
-	file_pk_id,
-	created_by,
-	created_date
-)
-SELECT
-	derived_bioassay_data_pk_id,
-	characterization_pk_id,
-	derived_bioassay_data_pk_id,
-	'DATA_MIGRATION',
-	SYSDATE()
-FROM cananolab.derived_bioassay_data
-ORDER BY characterization_pk_id, list_index
-;
-*/
-
--- version 2
 INSERT INTO canano.derived_bioassay_data
 (
 	derived_bioassay_data_pk_id,

)
SELECT sample_pk_id,
	file_pk_id
FROM cananolab.sample_report;

insert into canano.nanoparticle_sample_report
(

	'DATA_MIGRATION',
	SYSDATE()
FROM cananolab.surface_chemistry
ORDER BY surface_pk_id, list_index
;

INSERT INTO canano.protocol_file
(
