Materialized View Logs on Log shipped secondary server database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Working with Oracle » Materialized View Logs on Log shipped...

Materialized View Logs on Log shipped secondary server database

Rate Topic

Display Mode

Topic Options

Author

Message

sqlbi.vvamsi

Posted Friday, November 30, 2012 10:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:11 PM
Points: 48, Visits: 268

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

GilaMonster

Posted Friday, November 30, 2012 12:56 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:35 PM
Points: 37,650, Visits: 29,901

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

sqlbi.vvamsi

Posted Friday, November 30, 2012 1:17 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:11 PM
Points: 48, Visits: 268

Based on what I know, Materialized View Log is a master table that can capture deletes/inserts/updates just like CDC tables.

Post #1391534

GilaMonster

Posted Friday, November 30, 2012 2:56 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:35 PM
Points: 37,650, Visits: 29,901

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

sqlbi.vvamsi

Posted Friday, November 30, 2012 3:47 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:11 PM
Points: 48, Visits: 268

That's right. I'm looking for an oracle solution. Perhaps, I'm at wrong place. Thanks.

Post #1391582

PaulB-TheOneAndOnly

Posted Monday, December 03, 2012 7:38 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:03 AM
Points: 2,979, Visits: 4,389

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 »

Permissions