Post reply

Import tables from Azure to premise database

  • October 26, 2015 at 12:13 pm

    #322090

    We would like to import some tables from Microsoft azure data mart to our local database on the server of our premise for some purpose.

    Any one knows how to do that?

    Thanks,

  • October 27, 2015 at 9:39 pm

    #1835920

    Integration Services would be my first choice - either using "Import Data..." (available in Management Studio when connected to the on-premises database) or using SQL Server Data Tools

  • October 27, 2015 at 11:50 pm

    #1835932

    Azure Data sync Framework is a tool created specifically to sync tables to and from Azure.

    Jayanth Kurup[/url]

  • October 28, 2015 at 9:52 am

    #1836118

    Thanks, SSIS is the way I am planning to do too.

    Just check if there is other way.

    For Azure Data sync Framework, I read it, it seems to need premise SQL server as Source, and Azure as destination, but for my purpose is opposite direction.

    We would like to import from Azure to premise nightly. I wonder if this tool can do that.

    The purpose we import is for report performance because of the big million of records that in the remote Azure databases. so the speed is slow if we directly create report upon Azure SQL database. so we would like to bring it to premise.

    Thanks,

    Xiaowei

  • October 28, 2015 at 10:49 am

    #1836146

    Data sync can do bidirectional ,premise to cloud and vice versa but considering the volume of data Ssis might be more better.

    Jayanth Kurup[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply