Managing Roles when using Windows authntication & Form authentication

As i know that when using Form Authentication with asp.net mvc web applications, then asp.net mvc will automatically create a membership database the stores the user name, password, roles, etc. and I can write my own controller to add, edit, delete roles and assign users to roles etc.
But I have the following question:- 1. By default asp.net mvc will create the membership database on local/DB when using Form authentication . so what if I want to change the database location for my membership tables. do I have to manually move the tables, or asp.net mvc will re-create the tables on the new database automatically when i build the project? 2. If I use windows authentication, I will not get any membership database. But I can still use Roles. So where are these roles managed, and how I will be assigning users to roles when using windows authntication ? are these roles managed and created only inside Active directory ? and if I want to add a user to t ...