I think the general answer you're going to get is 'it depends.' If you have 'vanilla' requirements, haven't specialized your SQLServer environment and aren't exploiting any SQLServer-only / T-SQL (there might be compatibility issues depending on the SQL flavor used by your new-target RDBMS) only functions and features, your migration to any other RDBMS might be relatively straightforward (yes, I'm hedging my bets with 'might be' and 'relatively'). That's probably not the case, though . . . You probably already knew this, but you're going to need to invest some time in analyzing your current setup and comparing it with the feature-set / configuration options of whatever your target system is going to be.
That said, DB2 for z/OS is an option if you intend to not run Linux on z, otherwise any Linux compatible RDBMS is a candidate for replacement (Oracle / DB2 on Linux / PostegreSQL / MySQL). I'm not advocating one over the other, just outlining some options. Good luck! -----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Richards, Robert B. Sent: Thursday, March 25, 2010 8:20 AM To: IBM-MAIN@bama.ua.edu Subject: SQL Server replacement I am way out of my element on this topic, so I thought I'd post this query: If we were looking to replace Microsoft's SQL Server with something on System z, what would my options be and how much effort would be required to move it there? Bob --------------------------------------------------------- Robert B. Richards (Bob) US Office of Personnel Management 1900 E Street NW Room: BH04L Washington, D.C. 20415 Phone: (202) 606-1195 Email: robert.richa...@opm.gov<mailto:robert.richa...@opm.gov> --------------------------------------------------------- ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html