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:arsl...@arslist.org] On Behalf Of Marc Burick Sent: Wednesday, July 01, 2009 12:10 PM To: arslist@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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"