1 files changed, 25 insertions, 0 deletions
diff --git a/lib/gitlab/background_migration/copy_merge_request_target_project_to_merge_request_metrics.rb b/lib/gitlab/background_migration/copy_merge_request_target_project_to_merge_request_metrics.rb
new file mode 100644
index 00000000000..6014ccc12eb
--- /dev/null
+++ b/lib/gitlab/background_migration/copy_merge_request_target_project_to_merge_request_metrics.rb
@@ -0,0 +1,25 @@
+# frozen_string_literal: true
+# rubocop:disable Style/Documentation
+
+module Gitlab
+  module BackgroundMigration
+    class CopyMergeRequestTargetProjectToMergeRequestMetrics
+      extend ::Gitlab::Utils::Override
+
+      def perform(start_id, stop_id)
+        ActiveRecord::Base.connection.execute <<~SQL
+          WITH merge_requests_batch AS (
+            SELECT id, target_project_id
+            FROM merge_requests WHERE id BETWEEN #{Integer(start_id)} AND #{Integer(stop_id)}
+          )
+          UPDATE
+            merge_request_metrics
+          SET
+            target_project_id = merge_requests_batch.target_project_id
+          FROM merge_requests_batch
+          WHERE merge_request_metrics.merge_request_id=merge_requests_batch.id
+        SQL
+      end
+    end
+  end
+end