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,