USERS and GRANTS

Mar 2 at 9:01 PM
I just tested this for the first time (Migrating from SQL 2012 to 2008 R2), and I have a few things that did not transfer over.

1) I have one user in the database that did not get created in target.
2) I have a database role named MPS. The role was created, but none of the grants to all the objects (Tables/SPs/etc) were created, and thus the role has no permissions to any of the objects in my schema.

Is there something I'm missing, or does this tool not support these items?

Other than that, I very much like the tool thus far!!!

Thanks,
Travis
Coordinator
Mar 4 at 6:14 PM
Hi Travis,

No, you are not missing anything. That is one thing that I never put in. So, you are correct, that once you migrate your database (schema / data), you will have to migrate the users / permissions by hand.

Sorry,
George