photo

Adrian Rutter

shared this problem
3 months ago

Employees Involved

photo

DMT Support Team

Admin

Statistics

0
Comments
1
Views

Relates to

Share

1
votes

Unable to compare SQL Server (onsite) with Azure SQL Data Warehouse (migrated)

When attempting to compare an onsite DB with an Azure SQL Data Warehouse migration of it, the software does not show the columns within the tables. Are there any prerequisites for this to function, such as DBA privileges, or somesuch ?

Official Answer
photo Employee
DMT Support Team Posted 3 months ago

Ideally it needs to be a user with DBA role.

In case that is not possible, at least a user with read permissions to system tables/views and rw to the database itself.

Please use 'contact us' form in case you still have this issue.

We may need to reach you out to clarify some technical details.

Thanks,

Alex.

Leave Comment

photo

Attach files...

The file must be a jpg, gif, png, bmp, ico, pdf, doc, rtf, txt, zip or rar no more than 2M