none
How to connect on premise server to azure SQL database? RRS feed

  • Question

  • From: DBA @DBA_SQL via Twitter

    @AzureSupport - I need to know steps to take sql database backup from onpremises to azure portal.

    I have an onpremises sql server. I need to know steps to take backup from Onpremises to azure for sql database.

    i am a first time user of azure so i need a basic level details for this.

    Thanks,

    @AzureSupport


    Friday, February 26, 2016 7:54 AM

All replies

  • Restoring a backup from SQL Server into Azure SQL database is not supported. There are a few other ways to migrate an on-premises SQL Server database to SQL DB. Check out https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/

    Most are 1-time migrations without continual, incremental updates. Transactional replication is exception where you can continue to keep the Azure SQL DB fed with changes from the local SQL Server.


    No great genius has ever existed without some touch of madness. - Aristotle

    • Proposed as answer by Joseph Idziorek Saturday, February 27, 2016 12:25 AM
    Friday, February 26, 2016 5:02 PM