How to Refresh Database from Production to DR

• rajeshjaiswalraj

  SSCrazy

  Points: 2574

  More actions

  February 17, 2013 at 11:41 pm

  #274344

  Hi I am very new in SQL SERVER......

  I have two database in two difference instances. Database A and Database B

  Database A has some different data, different User, different Some permition, schema, role etc compare to B

  Database B also has some data, User, Some permition, schema, role etc

  I want to copy all data from A to B but i dont want to change permition, role etc in B database.

  Can some one please tell me how can i do this..............................

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  February 18, 2013 at 12:58 am

  #1588720

  You can use SSIS package which wil only transfer the data.

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)