manually inserting passwords into the aspnet_membership table

• SQLSandwiches

  SSCrazy

  Points: 2143

  More actions

  February 12, 2009 at 9:27 am

  #99474

  We are redesigning our databases and are now going to be using all of the aspnet_XXX tables. We are running to the problem of how to insert the existing usernames and passwords from the old (unencrypted) login tables into the new aspnet_membership table. The password field is an encrypted nvarchar(128) field.

  Anyone have this problem?

• sqltung

  Hall of Fame

  Points: 3962

  More actions

  February 13, 2009 at 2:28 pm

  #943935

  Yin Halen (2/12/2009)

  ---

  We are redesigning our databases and are now going to be using all of the aspnet_XXX tables. We are running to the problem of how to insert the existing usernames and passwords from the old (unencrypted) login tables into the new aspnet_membership table. The password field is an encrypted nvarchar(128) field.

  Anyone have this problem?

  Does your application have an option to store as unencrypted? You may have to do that if you can't insert the data otherwise. I'll bet the encryption routine is in the .NET app.

  On another topic, Yin Halen, have you ever worked with Sagar? Anyway, I dig the music..