Listing Thumbnail

    Ubuntu 20.04 with Microsoft SQL Upgrade and Migration Wizard

     Info
    Deployed on AWS
    AWS Free Tier
    Migrating and upgrading Microsoft SQL Server workloads from unsupported Windows OS versions, such as Windows 2008 R2 running SQL Server 2008, can pose significant challenges due to security vulnerabilities. Our solution presents a low-risk approach using a backup of your SQL data, leaving your existing production SQL Server unaffected. This process has been automated for migration to a supported Microsoft SQL 2019 Server. You can establish a Red Hat server in your preferred Datacenter or Cloud, and using your latest Microsoft SQL Server backup, employ the 'Modernize for MS SQL' tool to set up the Red Hat server to run Microsoft SQL 2019, completing the migration of your databases.

    Overview

    Play video

    As we know, several Microsoft Operating Systems versions have either reached the end of their support life or extending their support comes with a high cost. Migrating away from these unsupported systems becomes particularly challenging when they host important services such as Microsoft SQL Server. A good example of such a scenario is a Windows 2008 R2 Server running Microsoft SQL Server 2008. This setup is not only unsupported, but it also brings along numerous security vulnerabilities due to the lack of new Operating System patches.

    This problem begs for a solution and our approach provides a feasible one. We've developed a method that has a minimal risk factor since it relies on a backup of your SQL data. This process does not have any impact on your current production SQL Server environment, hence ensuring continuity of your operations.

    What does this process entail? Well, the migration towards a supported Microsoft SQL 2019 Server is now fully automated. The first step involves building a Red Hat server. You have the flexibility to set this server up in your Datacenter or a Cloud environment of your choice, aligning with your company's IT policies and resources.

    Once the Red Hat server is up and running, you will use your most recent Microsoft SQL Server backup, which should come from your Windows Server. We have developed a tool, called 'Modernize for MS SQL,' designed to streamline and simplify the transition process. When you use this tool with your SQL Server backup, it will configure the Red Hat server to run Microsoft SQL 2019. Additionally, this tool will handle the migration of your databases, ensuring that your data is successfully transferred to the new environment.

    This solution not only resolves the issue of operating an unsupported system but also ensures that you can continue to leverage the powerful features and capabilities of Microsoft SQL 2019 Server in a secure and updated environment. It provides a seamless transition that safeguards your data and operations while enhancing your IT infrastructure's overall security and efficiency.

    Highlights

    • Low-Risk Migration: Our approach ensures a low-risk transition from unsupported systems to a more secure and updated environment. Leveraging the backup of your SQL data, our method guarantees zero impact on your existing production SQL Server, allowing for uninterrupted business operations.
    • Automated SQL Server Upgrade: The migration to a supported Microsoft SQL Server 2019 is completely automated. You can easily build a Red Hat server in your preferred environment, eliminating the hassles associated with manual migration and reducing the chance of human error.
    • Modernize for MS SQL Tool: Our tool is designed to facilitate the transition process. By using your SQL Server backup, it configures the Red Hat server to run Microsoft SQL Server 2019 and handles the migration of your databases, ensuring a smooth and error-free transition.

    Details

    Delivery method

    Delivery option
    64-bit (x86) Amazon Machine Image (AMI)

    Latest version

    Operating system
    Ubuntu 20.04

    Deployed on AWS

    Unlock automation with AI agent solutions

    Fast-track AI initiatives with agents, tools, and solutions from AWS Partners.
    AI Agents

    Features and programs

    Financing for AWS Marketplace purchases

    AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
    Financing for AWS Marketplace purchases

    Pricing

    Ubuntu 20.04 with Microsoft SQL Upgrade and Migration Wizard

     Info
    Pricing and entitlements for this product are managed through an external billing relationship between you and the vendor. You activate the product by supplying a license purchased outside of AWS Marketplace, while AWS provides the infrastructure required to launch the product. AWS Subscriptions have no end date and may be canceled any time. However, the cancellation won't affect the status of the external license.
    Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator  to estimate your infrastructure costs.

    Vendor refund policy

    Email sales@cyberautomation.com.au  with order number and reason. We'll review and refund if approved. Non-refundable items exist. We may modify policy without notice.

    How can we make this page better?

    We'd like to hear your feedback and ideas on how to improve this page.
    We'd like to hear your feedback and ideas on how to improve this page.

    Legal

    Vendor terms and conditions

    Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .

    Content disclaimer

    Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.

    Usage information

     Info

    Delivery details

    64-bit (x86) Amazon Machine Image (AMI)

    Amazon Machine Image (AMI)

    An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.

    Version release notes

    Migrate your Microsoft SQL Databases from from: Windows Server Operating System To: Ubuntu 20.04 - Microsoft SQL Server 2022

    Additional details

    Usage instructions

    1. Log into the AMI via ssh: ssh <ip address of the AMI>

    2. Navigate to the /home/ubuntu directory, if you don't know how, after logging in just type: cd /home/ubuntu

    3. Then enter the LicenseKey that you have been provided. Lets call the Licensekey you were provided yourkey, so you would do the following and subsituting yourkey with the Licensekey you were provided: echo "yourkey" > /home/ubuntu/LicenseKey.Key

    4. Check to see if ModernizeMSSQL has downloaded into the /home/ubuntu directory: ls -las /home/ubuntu

    5. Once you see the ModernizeMSSQL binary, then type: sudo ./ModernizeMSSQL

    • If you have an error when you run the command "sudo ./ModernizeMSSQL" then wait a couple of minutes because the ModernizeMSSQL might not have completely downloaded.

    Resources

    Vendor resources

    Support

    Vendor support

    Support is provided via email at support@cyberautomation.com.au 

    AWS infrastructure support

    AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.

    Similar products

    Customer reviews

    Ratings and reviews

     Info
    0 ratings
    5 star
    4 star
    3 star
    2 star
    1 star
    0%
    0%
    0%
    0%
    0%
    0 AWS reviews
    No customer reviews yet
    Be the first to review this product . We've partnered with PeerSpot to gather customer feedback. You can share your experience by writing or recording a review, or scheduling a call with a PeerSpot analyst.