The following example shows how to transfer existing login account values to a new login profile. The login profile sa_lp is created with default database, default language, and authenticate with attribute values set to the same values of the login account ravi.
create login profile sa_lp with attributes from ravi