locked
SQL Server Sync Security RRS feed

  • Question

  • Alright, question.

    I'm just now getting into the Sync Framework (Yeah, I'm late). I managed to get two folders to sync with each other which I was surprised how easy it was.

    When syncing with SQL Server, does security permissions on tables get synced as well?


    Owner, Quilnet Solutions
    Tuesday, December 21, 2010 8:55 PM

Answers

  • Thanks for using Sync Framework.

    When syncing with SQL Server, we only sync necessary table metadata such as involved columns, keys etc. Security permissions are not synced over. Actually because different servers may have different security mechanism or even logins so it's hard for sync to do this job.

    • Marked as answer by Quilnux Wednesday, December 22, 2010 12:39 AM
    Wednesday, December 22, 2010 12:38 AM
    Answerer

All replies

  • Thanks for using Sync Framework.

    When syncing with SQL Server, we only sync necessary table metadata such as involved columns, keys etc. Security permissions are not synced over. Actually because different servers may have different security mechanism or even logins so it's hard for sync to do this job.

    • Marked as answer by Quilnux Wednesday, December 22, 2010 12:39 AM
    Wednesday, December 22, 2010 12:38 AM
    Answerer
  • Thanks for using Sync Framework.

    When syncing with SQL Server, we only sync necessary table metadata such as involved columns, keys etc. Security permissions are not synced over. Actually because different servers may have different security mechanism or even logins so it's hard for sync to do this job.


    Understood. I figured as much but I didn't want to assume.

    Thanks. Have a good Christmas!


    Owner, Quilnet Solutions
    Wednesday, December 22, 2010 12:39 AM