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

ODS - Operation Data Source with small data comapring to Production to gain performance. Expand / Collapse
Author
Message
Posted Thursday, December 27, 2012 3:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 17, 2014 2:10 AM
Points: 16, Visits: 234
Hi,

we are in the process of building ODS - Operational Data source, ODS will contain only current 3yrs data, whereas Production server contain 10yrs old data.

What I need is a smaller sized database which contain data for last 3yrs than the production database which contain data for 10yrs.
I need a way to have the ODS server storing only the most recent data. Any ideas or recommendations on this?

is it possible to delete data from a read only standby database that imports shipped log files?
I know this shouldn't be possible because the deletion would change the LSN and the log shipping should break.

We try replication but require more maintanance.
we can create ETLs but they may kill performance of the prod server.

Regards
Sachin
Post #1400532
Posted Thursday, December 27, 2012 3:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 17, 2014 2:10 AM
Points: 16, Visits: 234
How about snapshot ?

we can take DB snapshots on PROD and execute ETL on snapshot. let me know your view / recommendation on this.
Post #1400536
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse