Post reply

Sync database roles in new MSSQL instance

  • June 13, 2016 at 12:15 am

    #319464

    Recently I am working on the migration and want to sync each database role properties from old server to new server as I see many objects are missing in the new database role . Can help me achieve this instead of opting manually ?

  • June 13, 2016 at 8:11 am

    #1884660

    Use a compare tool, like SQL Compare. These will let you see what's different between databases and generate a script you can run. SQL Compare can even be driven from the command line, so automated to run every day.

    Disclosure: I work for Redgate Software.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply