How to migrate Microsoft SQL Server to Oracle Autonomous Database.
You can shift and change a Microsoft SQL Server database over to Oracle Autonomous Database 19c on an Oracle Cloud Infrastructure (OCI) utilizing Oracle SQL Developer. One can lead and deal with the whole data change and offline data migration with Oracle SQL Developer. Finishing time shifts and is not set in stone by the size of the source SQL Server database and the organization transmission capacity between the source and Oracle Cloud Autonomous Database. It is recommended that for a better exchange insight, use Oracle Cloud Infrastructure Fast Connect between on-premises and Oracle Cloud.
Architecture
This architecture utilizes Oracle Cloud Infrastructure File Storage to transfer data from an on-premises Microsoft SQL Server organization to an Oracle Autonomous Data Warehouse. The architecture is also similar while relocating from another cloud service provider to Oracle Cloud. Oracle Cloud Infrastructure Fast Connect or IPSec VPN gives private connectivity between on-premises data center, cloud service provider, and Oracle Cloud Infrastructure (OCI).
After migrating the data to OCI, one can use the built-in machine learning, analytics, and AI tools to run complex queries across multiple data types, and build sophisticated analytical models.
- Data scientists can also use Oracle Cloud Infrastructure Data Catalog to explore, discover, and analyze data
- Business analysts can access and visualize information.
- Developers can build data-driven applications.
Preparing environment
Required Services and Roles
- Oracle Cloud Infrastructure
- Oracle SQL Developer
- Microsoft SQL Server
- Oracle Cloud Infrastructure File Storage
Provision of Autonomous Database on OCI
Provision of an Oracle Autonomous Database instance on Oracle Cloud Infrastructure according to the size requirements of the source MS SQL Server database.
Perform the following prerequisite steps as necessary:
- Open Oracle Cloud Infrastructure Console.
- From the left navigation menu click Oracle Database. Then, depending on your workload click Autonomous Data Warehouse, Autonomous JSON Database, or Autonomous Transaction Processing. This example uses Autonomous Data Warehouse.
- Choose your region.
- Choose your Compartment.
- Create Autonomous Database.
- Fill in the basic information for the Autonomous Database.
- Choose a compartment.
- Display name: Specify a user-friendly description or other information that helps you easily identify the resource. The display name does not have to be unique.
- Choose a workload type
- Choose a deployment type.
- Configure the database.
- Create administrator credentials. Set the password for the Autonomous Data Warehouse Admin user.
- Choose network access.
- Choose a license type
