I am migrating a set of databases to a new SQL Server instance. Backing up and restoring the databases worked just fine, as did migrating logins with sp_help_revlogin however none of the permissions for the logins were preserved. Is there a way to migrate the permissions along with the logins?