SQL Server DB migration to Azure SQL Database
|
|
$170
hour
ADD TO CART
|
Responsibilities:
For SQL migration, we offer two approaches. The first approach is fairly uncomplicated, however it may require substantial downtime. The second approach, which is more advanced, minimizes downtime.
Method 1: Migration with Downtime
- Assess database compatibility using Data Migration Assistant (DMA).
- Prepare fixes as Transact-SQL scripts.
- Create a transactionally consistent copy of the source database, ensuring no further changes.
- Apply fixes to the database copy.
- Export the database copy to a .BACPAC file.
- Import the .BACPAC file as a new Azure SQL database.
Method 2: Transactional Replication
- Removing the SQL Server database from production.
- Set up Azure SQL Database as a subscriber to the SQL Server.
- Configure transactional replication.
- Migrate applications to point to Azure SQL Database.
Client Responsibilities:
- Appoint a dedicated point of contact.
- Configure networking equipment.
- Provide access to servers and systems.
- Perform DNS changes if required.
Excluded Services:
- Detailed project closeout report.
Prerequisites:
- Azure subscription required.
Plan:
- Kick-off meeting.
- Define backup points.
- Start deployment.
- Finalize deployment.
Verify and address any issues.