question

EmmanuelToledoSepulvedaUSIFS-7914 avatar image
0 Votes"
EmmanuelToledoSepulvedaUSIFS-7914 asked ·

How to add new tables to an existing Elastic Db

I have the need to add tables and stored procedures to existings shards, could anyone point me to the right direction on how to do this?

azure-sql-database
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered ·

Hi @EmmanuelToledoSepulvedaUSIFS-7914, welcome to Microsoft Q&A forum.

Adding table to database in elastic pool is same as we do in any azure Sql Database. We can use SSMS to connect to server and database and create any database objects. Please check the screenshots below:

1) Connecting to database server:
72247-image.png

2) Creating tables or stored procedure:
72304-image.png

We can also use Azure Data Studio for the same.

Please let us know if this helps or else we can discuss further.

If answer helps, please mark it 'Accept Answer'





image.png (64.9 KiB)
image.png (25.9 KiB)
· 3 ·
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EmmanuelToledoSepulvedaUSIFS-7914 avatar image EmmanuelToledoSepulvedaUSIFS-7914 ·

Thanks @AnuragSharma-MSFT for the information, one last thing. Do I need to also modify the ShardedDatabaseSchemaInfosGlobal table in the Shard Manager to add the new tables as part of the Sharded table set xml object?

0 Votes 0 ·
AnuragSharma-MSFT avatar image AnuragSharma-MSFT EmmanuelToledoSepulvedaUSIFS-7914 ·

Hi @EmmanuelToledoSepulvedaUSIFS-7914, thanks for reverting back. I am checking this and will get back at the earliest.

0 Votes 0 ·
AnuragSharma-MSFT avatar image AnuragSharma-MSFT AnuragSharma-MSFT ·

There are a set of tables that get created automatically while we define our shard map manager database. As we add the databases that would be part of sharding and the tables that would be sharded, this information is added by itself into the ShardedDatabaseSchemaInfosGlobal table. We can open the schema xml to check which all tables are part of sharding databases.

0 Votes 0 ·