Permissions to do SQL Compare

• ajay.g

  Ten Centuries

  Points: 1117

  More actions

  May 22, 2012 at 4:34 am

  #258515

  Hi,

  I would like to know what permissions exactly the Login should've, inorder to do SQL Compare between two DBs which exist on diff. Servers. The Login should've same permissions on both the Servers or can've diff. permissions...???

  Please clarify my doubt, as I need to do a Compare based on the clarification.

• Grant Fritchey

  SSC Guru

  Points: 399278

  More actions

  May 22, 2012 at 6:20 am

  #1491021

  The necessary permissions are documented right here on the Red Gate web site.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning