Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SQL Server Sync Security RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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