title: User Migration with DotNetNuke 5.6.2
body: <p>I need to transfer users info from the live DB to its new home (which was created via a backup of the live DB so Im only looking to port new users across.(running sql sqerver 2005)</p>
  
  <p>I can Transfer the aspnet_ tables without any issue</p>
  
  <p>However when I try to do the users table it errors with:</p>
  
  <blockquote>
    <p>Msg 512, Level 16, State 1, Procedure Mailing_list, Line 18
    Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used as an expression.</p>
  </blockquote>
  
  <p><strong>Query</strong></p>
  
  <pre><code>begin TRAN
  SET IDENTITY_INSERT TargetDB.dbo.users ON
  
  INSERT INTO TargetDB.dbo.users (UserId, UserName, FirstName, LastName, IsSuperUser,
                                  AffiliateId, Email, DisplayName, UpdatePassword)
  (SELECT dnnu.UserId, dnnu.username, dnnu.firstname, dnnu.lastname, 
          dnnu.isSuperuser, dnnu.AffiliateId, dnnu.Email, dnnu.DisplayName, 
          dnnu.UpdatePassword
  FROM LiveDB.dbo.users dnnu
      INNER JOIN LiveDB.dbo.aspnet_users u
          ON (dnnu.username = u.username)
  
  WHERE dnnu.username NOT IN (SELECT username
                              FROM TargetDB.dbo.users))
  
  SET IDENTITY_INSERT TargetDB.dbo.users OFF
  commit TRAN
  </code></pre>
  
  <p>I have also run this same section of code on at least two other Database with no issues</p>
  
  <p>Any help would be greatly appreciated</p>
  
  <p>Thanks in advance
  Matt</p>