Update destination table with source table's data... 
 
 
DECLARE @BusinessEntityID as NVARCHAR(50);
DECLARE @BusinessName as NVARCHAR(50);
 
DECLARE @BusinessCursor as CURSOR;
 
SET @BusinessCursor = CURSOR FOR

SELECT namesurname, usern
 FROM [SourceDB].[dbo].[Users];
 
OPEN @BusinessCursor;
FETCH NEXT FROM @BusinessCursor INTO @BusinessEntityID, @BusinessName;
 
WHILE @@FETCH_STATUS = 0
BEGIN
 --PRINT cast(@BusinessEntityID as VARCHAR (50)) + ' ' + @BusinessName;
 
 UPDATE [DestinationDB].[dbo].[Users] SET Usern=@BusinessName WHERE Name=@BusinessEntityID
 
 FETCH NEXT FROM @BusinessCursor INTO @BusinessEntityID, @BusinessName;
END
 
CLOSE @BusinessCursor;
DEALLOCATE @BusinessCursor;