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 <stra...@unt.edu> 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: > arsl...@arslist.org] *On Behalf Of *Marc Burick > *Sent:* Wednesday, July 01, 2009 11:48 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Changing databases > > > > ** > Thanks Jennifer. > > How about replication? Does MS-SQL have a replication tool? > > Marc > > From: > > "Meyer, Jennifer L" <jennifer.me...@its.nc.gov> > > To: > > arslist@ARSLIST.ORG > > Date: > > 07/01/2009 12:26 PM > > Subject: > > Re: Changing databases > > Sent by: > > "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> > > > ------------------------------ > > > > > ** > 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:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Marc > Burick* > Sent:* Wednesday, July 01, 2009 12:10 PM* > To:* arsl...@arslist.org* > 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: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ -- If it were not for the gutter, my mind would be homeless! _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"