I am getting the below error while syncing the table between Azure DBs in Azure portal

Rajendra Goud-Mala 51 Reputation points
2022-12-04T16:29:59.41+00:00

I am trying to configure the table sync between two azure DBs.
I am getting the below error while syncing the tables between Azure DBs form Azure portal

Getting schema information for the database failed with the exception "Database object names with a '.', '[' or ']' are not supported. For more information, provide tracing ID ‘21924db6-b53f-45af-a524-30da50439516’ to customer support."

Please suggest and appreciate your help

Azure SQL Database
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Alberto Morillo 35,411 Reputation points MVP Volunteer Moderator
    2022-12-04T22:15:08.317+00:00

    Hello,

    The names of objects (databases, tables, and columns) cannot contain the printable characters period (.), left square bracket ([), or right square bracket (]).

    Please read this documentation for more information.

    Only removing the offending object(s) or setting a supported name or length for the object or objects may work.

    0 comments No comments

  2. Bjoern Peters 8,921 Reputation points
    2022-12-05T12:31:51.413+00:00

    Hi @Rajendra Goud-Mala

    What exactly are you trying?
    Doing this with a GUI or via script?
    Can you show us a screenshot of your database and table names and the error message.

    As Alberto already stated it is not allowed to use special characters in database and/or tablenames.

    0 comments No comments

  3. Rajendra Goud-Mala 51 Reputation points
    2022-12-05T14:51:51.52+00:00

    Hi Bjoern/Alberto. I have configured the sync between two dbs and it is working fine now.
    appreciate your prompt response and help.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.