January 26, 2007 at 11:23 am
I currently have snapshot replication setup between 2 data marts. The thinking is that one is used primarily for the ETL process and the other is used for report generation. When the process completes on the ETL server we would like to push the snapshot over to the presentation server. Is there a way to initiate the pushing of the snapshot after the etl process is complete? We are currently using Standard Editions of Sql Server 2005 and as I understand it, Mirroring is not available on this edition. Finally is there a better way to achieve what we are wanting to do? Any advice would be greatly appreciated. Thanks in advance!
-KrustyDeKlown
January 26, 2007 at 1:11 pm
After your etl process you can reinitialize subscription using tsql..
Check BOL top "How to: Reinitialize a Subscription"
http://msdn2.microsoft.com/en-us/library/ms146877.aspx
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply