Hi Fred... It would be a one time copy that is repeatable on a 3-6 month cycle for Staging and Dev.
We would just want to be able to dump real data to make sure that nothing is missed in Q&A for Testing. However for reporting it would be a constant sync for about 12 metric collection tables that have been developed (Migrator will work for this). On Jul 15, 9:50 am, "Grooms, Frederick W" <frederick.w.gro...@xo.com> wrote: > Is this a one-time copy (or maybe like once a quarter type of thing), or a > constant sync. > > Fred > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Elry > Sent: Thursday, July 15, 2010 7:47 AM > To: arsl...@arslist.org > Subject: SQL Database Replication > > Hi Folks... > > I am going to ask this question again - because I have never seen a > definitive answer. > > Here is what we have: > > 1) Independent SQL Database Tier (2005). > 2) ARSystem Application Tier (7.5 Patch 2). > 3) Mid-tier (7.5 Patch 2). > > Environments: > > 1) Sandbox > 2) Development > 3) Staging > 4) Production > 5) Reporting/Archiving (to be deployed). > > What we need to do is the following: > > 1) Update the Staging and Development environments with data from > production > 2) Replicate the Production database to our new Reporting/Archiving > environment. > > Options being considered: > > A) Database Replication. > B) BMC Remedy Migrator. > C) DSO. > > We understand and know how to use options B) and C). We are looking > for feedback from anyone who is successfully using option A). > Specifically... > > 1) What type of replication. > 2) Are there configuration paramaters that are retained at the > database level that need to be changed. > 3) Are there any considerations for ar.cfg. > > I have never seen a white paper on database replication ( I understand > that this method is unsupported). > > Any feedback would be greatly appreciated. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text > - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"