{"id":109334,"date":"2026-03-18T14:01:06","date_gmt":"2026-03-18T14:01:06","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=109334"},"modified":"2026-04-07T13:56:18","modified_gmt":"2026-04-07T13:56:18","slug":"how-to-migrate-from-on-prem-to-the-cloud-uncovering-legacy-system-skeletons","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/cloud\/how-to-migrate-from-on-prem-to-the-cloud-uncovering-legacy-system-skeletons\/","title":{"rendered":"How to migrate from on-prem to the cloud: uncovering legacy system ‘skeletons’"},"content":{"rendered":"\n

In this article, Pat Wright explains<\/strong> how to identify hidden risks in legacy applications before moving to the cloud. It features practical advice and guidance to avoid migration failures and surprises.<\/strong><\/p>\n\n\n\n

I have worked in very few companies that had applications that were only a few years old or were for greenfield projects. Typically, I find companies have applications that are more than five years old and have been running on the same hardware for many years more. For these applications, making a move to the cloud<\/a> can be a challenge.<\/p>\n\n\n\n

A DB migration I was recently involved with had an application that had been running on a local server, in the office, for over five years. It was in maintenance mode and didn\u2019t really have much new code being written for it. It was critical to the company, and they were working on moving all the systems to the cloud. When it came time for the migration of this DB, however, a problem arose.<\/p>\n\n\n\n

The problem with this migration, explained<\/h2>\n\n\n\n

We went through the same steps as we had done with others, but discovered that this particular application didn\u2019t work without specific Database System Admin permissions<\/a>. These permissions weren\u2019t easy to set up in the cloud, so the first testing we did with the application failed.<\/p>\n\n\n\n

We didn\u2019t have any documentation around this, and none of the original engineers who understood what was needed from the application were around to help. Thankfully, in the end we were able to provide the proper permissions to the application to get it working in the cloud, using a temporary solution we created. This temporary solution allowed me to formulate the following advice to ensure the same doesn’t happen to you.<\/p>\n\n\n\n

How we tackled the permissions issue<\/h2>\n\n\n
\n
    \n
  1. Start a task force to list all applications and products that exist in the organization. 

    <\/li>\n\n\n\n
  2. Identify which applications are still needed and which ones need to change. This should be done in parallel with getting ready for the migration

    <\/li>\n\n\n\n
  3. Track down documentation if possible. Introduce a process to create the documentation of the system as you migrate.

    <\/li>\n\n\n\n
  4. Start building a test plan – or run a \u201cquick test\u201d with a copy of the application in the cloud – to find simple problems.

    <\/li>\n\n\n\n
  5. Find genuine users of the application within your organization and make sure they do the testing. For example, somebody working in accounting is often the best person to test these items.

    <\/li>\n\n\n\n
  6. Try to categorize the applications both by risk and by length of time for migration. This is important for future steps.<\/li>\n<\/ol>\n<\/div>\n\n\n

    I hope this has helped you to find the skeletons in your systems and I am looking forward to helping you in the next article.<\/p>\n\n\n\n

    \n
    \n
    \n
    \n

    Cloud adoption is accelerating, but database migrations aren\u2019t keeping pace. Find out why.<\/h3>\n
    \n The Cloud Migration Divide explores why complex, business-critical databases remain on-premises – and what\u2019s holding organizations back as confidence fails to scale with complexity. <\/div>\n <\/div>\n Download the free report<\/a>\n <\/div>\n <\/div>\n<\/section>\n\n\n
    \n

    FAQs: Uncovering legacy system 'skeletons' before a cloud migration<\/h2>\n\n

    1. What are \u201cskeletons in the closet\u201d in IT systems?<\/h3>\n
    \n

    They are hidden dependencies, outdated configurations, or undocumented features in legacy applications that can cause issues during cloud migration.<\/p>\n <\/div>\n

    2. Why do legacy applications fail during cloud migration?<\/h3>\n
    \n

    They often rely on old permissions, hardware setups, or undocumented behavior that doesn\u2019t translate easily to cloud environments.<\/p>\n <\/div>\n

    3. How can I prepare legacy systems for cloud migration?<\/h3>\n
    \n

    Audit all applications, review documentation, test early in the cloud, and involve real users in validation.<\/p>\n <\/div>\n

    4. What is the first step in a successful cloud migration?<\/h3>\n
    \n

    Create an inventory of all applications and identify which ones are still needed or require updates.<\/p>\n <\/div>\n

    5. Why is documentation important in cloud migration?<\/h3>\n
    \n

    Without documentation, critical system requirements may be missed, leading to delays or failures.<\/p>\n <\/div>\n

    6. Who should test applications after migration?<\/h3>\n
    \n

    Actual end users – often those who use the system daily – are best suited to identify real-world issues.<\/p>\n <\/div>\n <\/section>\n\n\n\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    Learn how to identify hidden risks in legacy applications before moving to the cloud. Practical tips to avoid migration failures and surprises.…<\/p>\n","protected":false},"author":346611,"featured_media":106856,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10,143523],"tags":[5336,4168,4170,159381,4214],"coauthors":[159379],"class_list":["post-109334","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud","category-databases","tag-cloud","tag-database","tag-database-administration","tag-how-to-migrate-from-on-prem-to-the-cloud-a-dba-stories-series","tag-migrating-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/109334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/346611"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=109334"}],"version-history":[{"count":6,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/109334\/revisions"}],"predecessor-version":[{"id":109435,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/109334\/revisions\/109435"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/106856"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=109334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=109334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=109334"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=109334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}