Thanks for your reply. I did originally try to develop my own membership provider but had trouble inserting it into Sitefinity. So, I have a customised version of the Sitefinity membership provider which works fine. If I add users and add profile data for the users through the admin page, I have no problem.
However, I have 176 web site users on the current web site. That site uses a customised version of the asp.net membership provider so all the user data is in the aspnet_xxx user and membership tables.
What I am trying to do is migrate that data from the aspnet_xxx tables in the database for the old site to the telerik_users and telerik_usermetainfo tables for the new site. The SQL server queries work without error and all the data is inserted in to the telerik_users and telerik_usermetainfo tables for the new site.
My problem is that the profile data does not show up. I can see all the users but none of those users has profile data available. I have modified profile fields including a user first name field which is populated with the username and not the users first name. The weird thing is that even though no profile data is displayed in the sf admin page, if I click the 'Save' button, sf throws a Primary Key Violation exception. So, it knows the data is there but can't read it?
I have tried every thing I can think of and now am out of ideas. I have just tried adding usermetadata with the 'telerik_UserMetaInfo_ins' stored procedure. Again, the data gets into the telerik_UserMetaInfo table but isn't displayed in the profile display / edit admin page.
I am about to try doing all this on a different server to see if it works on a different machine. I'll let you know how that goes but in the meantime if you have any other thoughts I would love to hear them!
Thanks and apologies for the long post.