Link to home
Start Free TrialLog in
Avatar of Eduardo Fuerte
Eduardo FuerteFlag for Brazil

asked on

Could you check if is this a valid way to replace data from a restore database to the current database by using MSSQLServer?

Hi Experts

Could you check if is this a valid way to replace data from a restore database to the current database by using MSSQLServer?

I need to replace a range of lines that is incorrect on the current database by using the restore database, I'm planning to do that:
-- -------------------------------------------------------------------------------------
-- Deleting the lines from target database
DELETE FROM INFOSAUDE.dbo.assistido a WHERE WHERE cpf ='';

-- Insert correct lines from RESTORE database

INSERT INTO INFOSAUDE.dbo.assistido a
  SELECT a2.id_assistido FROM INFOSAUDE_REST1302.dbo.assistido a2  WITH(NOLOCK) WHERE cpf ='';
-- -------------------------------------------------------------------------------------

Open in new window


Could you check?

Thanks in advance!
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Eduardo Fuerte

ASKER

Thank you for reply.