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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 11:20 AM
Points: 67, Visits: 242
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: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
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