question

RN-2284 avatar image
0 Votes"
RN-2284 asked RN-2284 commented

DataSync Agent Schema - Azure SQL

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-supported
5 |1600 characters needed characters left characters exceeded

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

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered RN-2284 commented

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

· 1
5 |1600 characters needed characters left characters exceeded

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

Thank you,

0 Votes 0 ·