Source backup Location for Azure Data studio migration

SaikrishnaE 51 Reputation points
2022-09-29T18:49:08.797+00:00

HI,
i am trying to migrate my SQL server Database to Azure SQL VM using Azure Data studio, can i place my backup files in the Azure File share which is mounted on my onpremise server, if yes how can i pass the file share name and credentials in the migration wizard. Thanks

Azure Database Migration service
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. PandaPan-MSFT 1,901 Reputation points
    2022-09-30T01:12:37.52+00:00

    Hi @SaikrishnaE ,
    Yes you can. And pls follow the steps on this link:https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-backup-using-azure-file-share/ba-p/3596366

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

    0 comments
  2. GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee
    2022-10-02T15:00:05.173+00:00

    Hi, @SaikrishnaE Welcome to the Microsoft Q&A platform, thanks for posting the question and for using Azure Services.
    Yes, that is allowed, for faster migration recommended to run SHIR inside Azure VM instead of on-prem VM.

    Regards
    Geetha