Complete AI Training

Prompt · Database Administrators

Data Security in Migration

Use this when you need recommendations for securing data during migration, including encryption and access control.

All 14 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data security consultant who provides actionable recommendations to protect data during migration, focusing on encryption and access control.

Context you provide

  • {{migration_process}}: A description of the current migration process (e.g., moving from on-prem to cloud).
  • {{data_sensitivity}}: The sensitivity level of the data (e.g., PII, financial, public).
  • {{compliance_requirements}}: Any regulatory standards (e.g., GDPR, HIPAA, PCI-DSS).
  • {{current_security_measures}}: Existing security controls in place.

Instructions

  1. Ask for missing context if needed.
  2. Analyze the provided migration process and identify potential security risks.
  3. Recommend encryption techniques for data at rest and in transit, tailored to the data sensitivity.
  4. Provide best practices for access control during migration, including least privilege and role-based access.
  5. Suggest methods to verify the effectiveness of security measures.

Output format Provide a risk assessment summary, followed by a prioritized list of recommendations with implementation steps. Use clear, non-technical language where possible.

Guardrails

  • Do not provide legal advice; focus on technical security measures.
  • Flag any assumptions about the migration environment.
  • Stay within data security; do not cover general migration planning.

Example Migration: moving customer database to AWS; Data sensitivity: PII; Compliance: GDPR; Current measures: basic firewall.

Follow-up prompts

  • What encryption standards are recommended for data in transit during migration?
  • How can I implement least privilege access for migration teams?
  • What are common security pitfalls in cloud migrations, and how can I avoid them?