Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Sunday, February 17, 2013 11:41 PM


Group: General Forum Members
Last Login: Monday, May 30, 2016 1:54 AM
Points: 100, Visits: 405
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



Group: General Forum Members
Last Login: Tuesday, July 19, 2016 4:34 AM
Points: 2,850, Visits: 4,076
You can use SSIS package which wil only transfer the data.

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