Has anyone Migrated BMC footprints Server and Database to Azure and Azure SQL Managed Instance?

Question

I am trying to Migrate the BMC Footprints Application Server to Azure VM and the Database to Azure SQL Managed instance. I am having problems with the Database when restoring it from a backup of our on-premise SQL instance. We have issues with Java database calls. Has anyone attempted to migrate BMS Footprints to Azure. Or attempted to migrate the Database to Azure Managed Instance?

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

Moving the BMC FootPrints application server to an Azure VM should be relatively straightforward, similar to moving it to any other server. However, you'll need to ensure that the Azure VM meets the system requirements for BMC FootPrints Service Core.

Ensure that the connection string in the application is updated to point to the new Azure SQL Managed Instance. the problems with Java database calls could be related to JDBC driver compatibility. Ensure you're using the latest JDBC driver compatible with Azure SQL Managed Instance.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

Answer 2

@Anaya, Luis - Admin Thank you for reaching out.

Microsoft provides a guide on how to migrate on-premises servers to Azure using Azure Migrate. This guide includes steps on how to prepare Azure for migration, set up the replication appliance, and more. Migrate machines as physical servers to Azure

Please take a look at the DMS doc https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online when migrating to Azure SQL managed Instance.

For the Java and JDBC with Azure SQL Database. This might help https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-java?view=azuresql