AWS Classroomnotes 02/Jan/2023

Installing SQL Server on Windows Server

  • We were unable to access due to ip configuration Refer Here to fix the problem.

    • Enable TCP/IP
    • In Properties of TCP/IP
      • IPALL: Enter 1433 as the tcp port
        Preview
  • Now we have source endpoint working
    Preview
  • Now lets start the migration
    Preview
    Preview
    Preview
    Preview
    Preview
  • Migration has 3 major options

    • Migrate data:
      • used for one time migration
    • Migrate data and replicate ongoing changes
      • used for incremental migration
    • replicate data:
      • Used to manually trigger replication for the databases where the data is migrated but sync is to be done
  • Verification Approach

    • Basic: Check counts of records
    • recommended approach: Execute tests on the application which relies on data migrated.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About continuous learner

devops & cloud enthusiastic learner