How to Refresh Database from Production to DR

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to Refresh Database from Production to DR...

How to Refresh Database from Production to DR

Rate Topic

Display Mode

Topic Options

Author

Message

rajeshjaiswalraj

Posted Sunday, February 17, 2013 11:41 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:19 PM
Points: 23, Visits: 98

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

Bhuvnesh

Posted Monday, February 18, 2013 12:58 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1421051

« Prev Topic | Next Topic »

Permissions