All database object names are produced automatically from our ORM. We do not have a convention. However this would not be a problem for migrating from older editions of the CMS. Migrations should be done using our API and not SQL - it would be impossible to know all table relations as information for different types is stored across several tables. Furthermore the whole system is rewritten from scratch and there are huge differences between the types in Sitefintiy 3.x and Sitefinity 4.0 making this even harder to migrate a website from an older version using SQL.
Sitefinity allows the use of custom membership providers as long as they implement the .NET MembershipProviders - there will be no problem to use your custom provider instead of the ones we ship Sitefinity with.
We are going to create a database object naming convention, however we are not going to change the already existing object names to ensure smooth upgrade process from the already release beta version to later releases.
the Telerik team
Check out Telerik Trainer
, the state of the art learning tool for Telerik products.