If you are migrating your site to a new server and generated a create table script of all the asp.net membership tables, It's most likely that your aspnet_SchemaVersions table is empty. If you populate aspnet_SchemaVersions table with the following values, you should be good to go.
Feature CompatibleSchemaVersion IsCurrentVersion
common 1 1
health monitoring 1 1
membership 1 1
personalization 1 1
profile 1 1
role manager 1 1