Cross database query using database name between shard and master db is not working in sql azure with sharding

Question

I have sharding in SQL Azure.

Basically my structure is like below:
1. Master Database
2. Shard0
3. Shard1

I store all non sharded client into master database but on special request from client, i create seperate shard from them.

While reporting sometimes i need to access master database data from say Shard0.

I have followed all articles available on internet like https://azure.microsoft.com/en-in/documentation/articles/sql-database-elastic-query-vertical-partitioning/

but somehow the [database].[dbo].[tablename] query is not working.

I am using SQL v12 in azure.

The above link is working because it has different table names in different database while in my scenario have same set of tables in master, shard0, shard1... shardn. So when i try to create external table in shard0 it will says that object is already exists because the table name are same and it is present in each database. — user6134726
– user6134726, Commented Sep 7, 2016 at 10:51

Torsten Grabs · Accepted Answer · 2016-09-09 21:10:24Z

2

You cannot use three part name syntax like above to refer to an external table. You query an external table as if it were a normal local table, i.e., use [schema_name].[external_table_name].

Hope this helps.

Thanks, Torsten

answered Sep 9, 2016 at 21:10

Torsten Grabs

4811 gold badge3 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cross database query using database name between shard and master db is not working in sql azure with sharding

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related