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

Materialized View Logs on Log shipped secondary server database Expand / Collapse
Author
Message
Posted Friday, November 30, 2012 10:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:17 PM
Points: 54, Visits: 349
Hello,

I've a database in primary server that log ships to a database in secondary server. I want to capture only deltas after log shipping is done. To do that, I'm wondering if I could implement materialized view log on each table in database on secondary server. pls let me know your 2 cents. Thanks.


Note:I cannot have access to primary server.
Post #1391452
Posted Friday, November 30, 2012 12:56 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 4:32 PM
Points: 42,458, Visits: 35,518
Not sure I follow what you're trying to do. What do you mean by 'materialized view log'?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1391525
Posted Friday, November 30, 2012 1:17 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:17 PM
Points: 54, Visits: 349
Based on what I know, Materialized View Log is a master table that can capture deletes/inserts/updates just like CDC tables.
Post #1391534
Posted Friday, November 30, 2012 2:56 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 4:32 PM
Points: 42,458, Visits: 35,518
There's no such term or feature in SQL Server as 'materialised view log'. A brief google search shows it's an Oracle feature.

What are you trying to achieve here?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1391568
Posted Friday, November 30, 2012 3:47 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:17 PM
Points: 54, Visits: 349
That's right. I'm looking for an oracle solution. Perhaps, I'm at wrong place. Thanks.
Post #1391582
Posted Monday, December 3, 2012 7:38 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
sqlbi.vvamsi (11/30/2012)
Based on what I know, Materialized View Log is a master table that can capture deletes/inserts/updates just like CDC tables.


You are correct, Materialized Views are an Oracle concept.

Having said that and just to clarify your statement above...

"Master table" is the base table (or tables) used to create a Materialized View.
"Materialized view" is a snapshot-in-time copy of a base table, or a subset of it.
"Materialized view log" is a log on the base table used make materialized view refresh quicker.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1391948
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse