You cannot copy the contents of a custom made table to Sitefinity tables freely via SQL statements. This will cause many problems considering ID, inheritance, hierarchy, sequence and restrictions. If you want to make changes by adding/removing/modifying users and user profiles you have to do so from the API. This will generate all of the entries listed above automatically while you only enter the needed data - name, email etc. The following sample shows how to create a user with administrative role through the API:
var userManager = UserManager.GetManager(
"Provider - Defualt or Ldap"
var user = userManager.CreateUser(
RoleManager roleManager = RoleManager.GetManager(
var role = roleManager.GetRole(
"Role you want to assign"
For a more detailed explanation on using Sitefinity API, please refer to our Documentation
Ivan D. Dimitrov
Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking
system and vote to affect the priority of the items