Sorry Konrad, as long as the migration process uses only the BMC-Remedy user tools there is no problem. Mai steps: - export definitions using Admin tool; DO NOT modify user & group form; - export data in ARX format - import ARX data using ARimport For example if the target ARS server is of version 7.5 use 7.5 tools. I have done it for: - ORCL to MS SQL 2000 & - MS SQL 2000 to ORCL Be very careful with data in de User & Group forms Daniel
________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Konrad Banasiak Sent: Tuesday, May 04, 2010 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: UNIX to Windows Remedy Migration ** Hello, With ARS it is not a problem. You will need to install on Windows ARS and all application, and import all workflow. Worst problem is with data. Because it is not easy convert database from ORACLE to MS SQL. I think you can only to copy data through the AR Importer from last ARS to new ARS, but if your database is very big, it can be hard to do. If you will install on Windows ARS on the oracle database, You will need to redo only database from last server. I made in one my client migration from Windows to Solaris, but database on all servers was the same. Konrad TopPositions Really only one secure Plugin SSO for BM Remedy AR System. Http://www.remedy-sso.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Daniel Condrea Sent: Tuesday, May 04, 2010 8:55 AM To: arslist@ARSLIST.ORG Subject: Re: UNIX to Windows Remedy Migration ** Hello All, In my opinion is much easier to admin a MS SQL than Oracle. You do not need any special skills. I have done it for 6 years. For better integration with other applications developed on Oracle we decided to migrate ARS server to ORCL. My advice is to my a machine with at least 2 separate controllers. Create a data base spread on 2 HDDs. Each HDD has to be on separate controller. On one HDD you must keep all field in a form except: attachments, memo and indexes. This technique applies to any RDBMS, including ORCL & MSSQL. It delivers a performance 10 times faster than a normal configuration. For MS SQL you can reserve some memory and processor. As I sayed I am not a database expert. For this reason I have maid mistackes whe ARS was running on MS SQL. After we migrated to ORCL, the Orcl DBA discoverd something running for 2 hours. Usesles to say that on MS SQL with the above configuration there was no penality regardin performange. Daniel ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ex Soundgarden Sent: Tuesday, May 04, 2010 9:37 AM To: arslist@ARSLIST.ORG Subject: UNIX to Windows Remedy Migration ** Hi ARSListers! We're currently planning to migrate existing Remedy environment in Sun Solaris to Windows Server. Below is the current system information: ARS 7.0.1 p10 running on Sun Solaris 10 Oracle 10g running on the same server Mid-tier 7.0.1 patch 6 running on MS Windows Server 2003 Memory size 8GB 4 UltraSPARC-IIIi virtual processors each running on 1.6GHz No ITSM applications installed. AR System is used for in-house developed applications (consisting of 1052 forms). average of 60-70 concurrent users. 600 registered users Initial possible scenario I'm currently looking at 2 options below: 1.Upgrade Remedy Server to latest version, purchase new hardware, and use the same platform (Solaris 10) . OR 2. Full migration to Windows Server 2008, including the database migration to SQL Server 2008. This is to reduce the cost of our support and maintenance for the servers Please give me any advice if what option is the best to implement. I'm really keen on just using the same platform (Solaris) but we currently don't have any Solaris/Oracle support which pretty much led us to looking at the Windows migration. If you can list all the pros and cons on doing any of the options, that will surely help me. In addition to that, may I know if anyone here has any experiences migrating from Unix to Windows environment recently or in the past? If you can let me know your success stories (and migration strategy), it would be greatly appreciated. Any good inputs will be appreciated. Regards... Gabud _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ********************************* This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not the intended addressee of this message, please cancel it immediately and inform the sender. ******************************** _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ********************************* This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not the intended addressee of this message, please cancel it immediately and inform the sender. ******************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
