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?

Hi @Emmanuel Toledo Sepulveda (US - IFS) , 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: 2) Creating tables or stored procedure: 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'

How to add new tables to an existing Elastic Db

Accepted answer

Anurag Sharma 17,571 Reputation points

2021-02-26T06:20:21.173+00:00

Hi @Emmanuel Toledo Sepulveda (US - IFS) , 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:

2) Creating tables or stored procedure:

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'
Please sign in to rate this answer.
Emmanuel Toledo Sepulveda (US - IFS) 21 Reputation points

2021-02-26T14:32:57.337+00:00

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?

Anurag Sharma 17,571 Reputation points

2021-03-01T09:47:01.297+00:00

Hi @Emmanuel Toledo Sepulveda (US - IFS) , thanks for reverting back. I am checking this and will get back at the earliest.

Anurag Sharma 17,571 Reputation points

2021-03-02T13:23:11.04+00:00

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.
Sign in to comment

How to add new tables to an existing Elastic Db

0 additional answers