Note:
.NET Framework is pre-installed in Microsoft Windows Vista and Windows 7/8/8.1/10.
dbForge Data Compare can compare and synchronize data of a SQL Server database. To perform this effectively, the user needs access to the schema and the data objects of a database and may require additional privileges depending on the options of data synchronization.
SQL Server 2008 and later
Task | Permissions |
Comparing data | db_owner role |
SELECT for the system view sys.sql_expression_dependencies | |
Synchronizing data | db_owner role |
SQL Server 2005
Task | Permissions |
Comparing data | db_owner role |
Synchronizing data | db_owner role |
Note:
- Minimum permission you need to have to compare data with the tool is VIEW DEFINITION permission.
- If you want to compare encrypted objects, you need a sysadmin role.
- With Data Compare, you can’t synchronize objects that are encrypted, in case they’re encrypted in the source.
SQL Server 2000
Task | Permissions |
Gathering information about the database schema | PUBLIC role |
Comparing data | db_owner role (recommended) or SELECT permissions (minimum) |
Synchronizing data | db_owner role (recommended) or INSERT and UPDATE permissions in addition to SELECT permissions |
In case you don’t have the right permissions: