We use log shipping for sending our ARSystem changes to our remote backup server and it works fine with no problems. Obviously, this works for us since we don't have requirements for realtime replication or mirroring.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Robert Molenda Sent: Friday, July 10, 2009 11:06 AM To: [email protected] Subject: Re: Changing databases ** Completely agree with the method that SQL Server handles replication/mirroring - it does work - but in order to perform a change to the form (read table) you must basically disable the replication, which removes the columns, add your fields, and then re-enable replication - which, since it's not enabled, transfer the entire table to the remote server. much less ties up SQL Server and your network for NN time... On Fri, Jul 10, 2009 at 8:40 AM, strauss <[email protected]<mailto:[email protected]>> wrote: ** SQL Server has several replication and mirroring options. Avoid those that add a column to every table - ARS hates that. If you are going to use 64-bit OS and SQL Server 2005 (which I recommend), use the Enterprise not the Standard version of SQL; there is an annoying memory handling issue in Standard x64 that is corrected in Enterprise x64. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Marc Burick Sent: Wednesday, July 01, 2009 11:48 AM To: [email protected]<mailto:[email protected]> Subject: Re: Changing databases ** Thanks Jennifer. How about replication? Does MS-SQL have a replication tool? Marc From: "Meyer, Jennifer L" <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> Date: 07/01/2009 12:26 PM Subject: Re: Changing databases Sent by: "Action Request System discussion list(ARSList)" <[email protected]<mailto:[email protected]>> ________________________________ ** You are aware that MS-SQL is a Microsoft product with all the baggage that entails? If you are prepared to take that on, it's a nice product. Runs smoothly, graphical user interface is easy to understand, really easy to schedule backups and perform regular maintenance. You'll be able to cross-train your DBAs on some other stuff. It plays best with other Microsoft products. Jennifer Meyer ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Marc Burick Sent: Wednesday, July 01, 2009 12:10 PM To: [email protected]<mailto:[email protected]> Subject: Changing databases ** Hi All, We are looking into switching from Sybase 12.5.4 to MS-SQL 2005. Currently, we are on ARSystem 7.1, patch 1. Anything special we should know above the documentation we have from Microsoft? Any suggestions/assistance is appreciated. Marc _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ ________________________________ Email correspondence to and from this sender is subject to the N.C. Public Records Law and may be disclosed to third parties. _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ -- If it were not for the gutter, my mind would be homeless! _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
