DataSync Agent Schema - Azure SQL

R.N 1 Reputation point
2020-04-01T19:34:10.053+00:00

Hi,

We have setup Azure SQL DataSync on-prem -> cloud and working fine.

SQL Sync Agent created DataSync schema and all of the objects for that schema, under the source database.

Q1. Is it possible in any way to move the tracking tables into a different database? The option to specify a different SQL server/database to host the tracking database is not available. confirmation will be great?

Q2. I am almost confident if we change the schema name and objects that are created under the source database, from DataSync to for example "msqta", the SQL DataSync Agent will break, correct?

The reason for the two questions, is that in our source database the account assigned a db_owner is attempting backup routines which fail. This is due to that it does not recognize non-dbo schemas and it cannot handle them. Revoking db_owner role for the account performing the routines (many of them!) could be problematic.

(I have already considered and evaluated (a working) schema segregation permissions grant by the way)

Thank you,

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,192 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,671 Reputation points
    2020-04-02T05:08:40.127+00:00

    You may post this question in a dedicated forum for Azure SQL in below. This QnA forum currently doesn't support Azure SQL related questions.

    https://social.msdn.microsoft.com/Forums/en-US/newthread?category=undefined&forum=ssdsgetstarted


    If the response helped, do "Mark as answer" or upvote it

    • Vaibhav