Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Refresh Database from Production to DR Expand / Collapse
Author
Message
Posted Sunday, February 17, 2013 11:41 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 6, 2014 5:21 AM
Points: 75, Visits: 270
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..............................
Post #1421041
Posted Monday, February 18, 2013 12:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:03 AM
Points: 2,840, Visits: 3,975
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
Post #1421051
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse