SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Using AlwaysOn to Refresh a Data Warehouse
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jbates99
Constraint Violating Yak Guru

368 Posts

Posted - 01/17/2014 :  11:57:45  Show Profile  Reply with Quote
I'm looking into the 2012 feature, AlwaysOn.
My instance for data warehouses will be 2012.
However the source instances are 2008 R2. I'm assuming that I can't use AlwaysOn to keep my warehouses refreshed with current data from the production databases, is that correct?

Currently I use snapshot replication to update the warehouse twice a day but I'm looking for an option that gives more real-time data.

Thanks, Jack

tkizer
Almighty SQL Goddess

USA
36653 Posts

Posted - 01/17/2014 :  12:59:36  Show Profile  Visit tkizer's Homepage  Reply with Quote
AlwaysOn isn't a solution for a data warehouse, but especially since you have 2012 and 2008 R2. The AlwaysOn databases will be SQL Server 2012 mirrored databases. So you can't have any schema changes like you would with a data warehouse. What you get with AlwaysOn is an identical database either real-time (synchronous) or with some latency (async).

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jbates99
Constraint Violating Yak Guru

368 Posts

Posted - 01/17/2014 :  13:14:21  Show Profile  Reply with Quote
Thanks, Tara. That's as I expected. Can you suggest a better technique than using snapshot replication which is what I have been using?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36653 Posts

Posted - 01/17/2014 :  13:24:17  Show Profile  Visit tkizer's Homepage  Reply with Quote
How about transactional replication? That's what I used in the past for our reporting instance. We did switch to AlwaysOn when we upgraded to SQL Server 2012, but it's because our reporting database had the exact same structure.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000