HomeAzure SQL DatabaseCross-database queries in Azure SQL Database

Comments

Cross-database queries in Azure SQL Database — 10 Comments

  1. Pingback:Azure SQL Database Cross-Database Queries – Curated SQL

  2. So is select * from sys.external_tables; actually pulling all the data from the external table into some kind of temp table in this database? Can you join to the external table without pulling everything?

  3. So far we can access azure from on premise using linked server,
    and azure from azure using the option from this article.
    Is there a way to access on premise from azure?

  4. Pingback:Azure SQL Database Pricing | James Serra's Blog

  5. Pingback:Multi-tenant databases in the cloud | James Serra's Blog

  6. Hello -OBJECT_NAME = ‘Customers’ –table name of remote table
    Are you referencing the remote table which exists already?
    I tried this and the cross table seemed to contain the same information as the remote table. What I would like to do is set up a type of freeze database and copy particular records to the freeze database periodically from the main database I have set up. Do you have any suggestions for this in Azure?

    • Hi Dia,

      Yes, the remote table already exists. You can setup a local table to have recent data, and a remote table to have older data. Then use a cross-database query to return all records.

  7. Pingback:Azure SQL Database pricing – Cloud Data Architect

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>