We were indulged in an another challenge during our cover of Azure. We had used the App Service (A platform as service) to host our Apps and Database, then we used the Logic Apps to automate process now we are laid with another challenge of migrating our archive data, from an Obsolete Oracle 9i to the cloud.
Challenges
What did we use
Microsoft came to assist us and they offered us to use the SQL Server Migration Assistant 7.8 for this task.
Observation
Although its not a successful task, but we were able to fix issues manually and migrated the data. Manual task went to the extent of even removing constraints, then resolve the issue and finally recreate them. This issue did haunt us the most. For integrity we had to ensure the Row count is equal in Source and Destination.
Challenges
- Database was more than 12Gigs and had Big Tables (Some went to extent of having more than 10 million records)
- Ensure what Source had is what the destination got
- Network interruptions
What did we use
Microsoft came to assist us and they offered us to use the SQL Server Migration Assistant 7.8 for this task.
Observation
Although its not a successful task, but we were able to fix issues manually and migrated the data. Manual task went to the extent of even removing constraints, then resolve the issue and finally recreate them. This issue did haunt us the most. For integrity we had to ensure the Row count is equal in Source and Destination.
