security implemented in an MDF - what about deployment?

[Progman]

I had setup the security from the asp.net configuration. I added roles and
user accounts. It created an mdf file with all the security related tables.

Now Id like to know what will happen when I deploy that MDF, which is a
database to a share web hoststing server. the server has an SQL Server on
it?

What will I have to do? Will I have to transfer that mdf database to the SQL
server one on the web hosting server?