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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
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"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: UNIX to Windows Remedy Migration
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. ***
Re: UNIX to Windows Remedy Migration
Daniel, This method you can use only if you have small installation of AR System. But if you have for example ITSM installed on your Remedy, It can be very hard to do, because ARImporter work very slow, and you have many forms to copy. But you can migrate only configuration, and requests, CMDB you can migrate through the AIE. Another option is to create some sql script which will copy all data from one database to another, but it can be very complicated. But you must remember that in many forms is stored the arserver name. for example Raport form. 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 12:32 PM To: arslist@ARSLIST.ORG Subject: Re: UNIX to Windows Remedy Migration ** 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
Re: UNIX to Windows Remedy Migration
If you have any direct sql calls you might nees to rebuild them. There are some differences there like distinvt and unique for an example. Respectfully; William Abdo -Original Message- From: Ex Soundgarden Sent: Tuesday, May 04, 2010 2:36 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 [The entire original message is not included] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: UNIX to Windows Remedy Migration
Konrad, I've never tested it out fully, but Misi has a program for these types of migrations, RRR|Chive (see http://www.rrr.se/en/). I believe there are others here on the list who *have* used it who might be able to provide some insight as to whether or not it will work in the situation Gabud is trying to work through. Good luck, Gabud! Matt R. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Konrad Banasiak Sent: Tuesday, May 04, 2010 5:21 AM 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"_ _a
Re: UNIX to Windows Remedy Migration
I've done this migration about 5 or 6 years ago. In my opinion that was the best decision my company made at that time. And yes I'm bias to SQL server database. The easiest option is to use AR Import to migrate your data to the new platform. Hopefully you have a programmer who can write you some windows scripts to run these imports for you. The smaller forms you can do a full copy and the larger forms it will run based on a date range. These windows scripts can be set to run at night so you don't have to watch it and it will not impact your current production during peak hours. Make sure to have some sort of data integrity check to validate all data was migrated over. Thanks, Timothy Palmer Ex Soundgarden To Sent by: "Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)"Subject 05/04/2010 02:36 AM Please respond to arsl...@arslist.o RG ** 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.
Re: UNIX to Windows Remedy Migration
If you are going to use an AR method or tool to do data imports, be sure to drop the indexes on forms that have more than about 100k records. That will speed the import process significantly. Once the data is imported, add the indexes back in. Rick -Original Message- From: Tim Palmer Date: Tue, 4 May 2010 10:03:59 To: Subject: Re: UNIX to Windows Remedy Migration I've done this migration about 5 or 6 years ago. In my opinion that was the best decision my company made at that time. And yes I'm bias to SQL server database. The easiest option is to use AR Import to migrate your data to the new platform. Hopefully you have a programmer who can write you some windows scripts to run these imports for you. The smaller forms you can do a full copy and the larger forms it will run based on a date range. These windows scripts can be set to run at night so you don't have to watch it and it will not impact your current production during peak hours. Make sure to have some sort of data integrity check to validate all data was migrated over. Thanks, Timothy Palmer Ex Soundgarden To Sent by: "Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)"Subject 05/04/2010 02:36 AM Please respond to arsl...@arslist.o RG ** 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 opt
Re: UNIX to Windows Remedy Migration
Would it if there are MERGE filters that do a search on the same form? Just a question as I have not validated if it would or not.. Joe From: Rick Cook To: arslist@ARSLIST.ORG Sent: Tue, May 4, 2010 10:09:26 AM Subject: Re: UNIX to Windows Remedy Migration If you are going to use an AR method or tool to do data imports, be sure to drop the indexes on forms that have more than about 100k records. That will speed the import process significantly. Once the data is imported, add the indexes back in. Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: UNIX to Windows Remedy Migration
Hi, I have done many upgrades using new hardware. I have usually chosen to do a fresh install, and then import the def-file with the application. I usually skip all system forms and manually modify the new install with any changes that has been made in the old system. After this, I use RRR|Chive to move the data from production to the new server. This may take up to a week, depending on the size of your system, but the final incremental transfer of data usually takes less than an hour. This give me a very clean new system. I have done this between Unix and Windows in both directions, and with the same/similar platform. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > 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 > > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > -- > This message was scanned by ESVA and is believed to be clean. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: UNIX to Windows Remedy Migration
Hi, RRR|Chive can drop indexes and recreated after the migration. Have you really seen a big speed difference by doing this? I measured the time for a 100k form with a lot of indexes, and could not see any difference in the speed. I do not remenber which database it was though... Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > If you are going to use an AR method or tool to do data imports, be sure > to drop the indexes on forms that have more than about 100k records. That > will speed the import process significantly. Once the data is imported, > add the indexes back in. > > Rick > > -Original Message- > From: Tim Palmer > Date: Tue, 4 May 2010 10:03:59 > To: > Subject: Re: UNIX to Windows Remedy Migration > > I've done this migration about 5 or 6 years ago. In my opinion that was > the best decision my company made at that time. And yes I'm bias to SQL > server database. The easiest option is to use AR Import to migrate your > data to the new platform. Hopefully you have a programmer who can write > you some windows scripts to run these imports for you. The smaller forms > you can do a full copy and the larger forms it will run based on a date > range. These windows scripts can be set to run at night so you don't have > to watch it and it will not impact your current production during peak > hours. Make sure to have some sort of data integrity check to validate > all > data was migrated over. > > Thanks, > > Timothy Palmer > > > > > Ex Soundgarden >AHOO.COM> To > Sent by: "Action arslist@ARSLIST.ORG > Request System cc > discussion > list(ARSList)"Subject >ORG> > > > 05/04/2010 02:36 > AM > > > Please respond to > arsl...@arslist.o > RG > > > > > > ** > > 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 email message and any attachments are for the sole use of the > intended recipient(s) and may contain information that is > proprietary to Ahold and/or its subsidiaries (Ahold) or otherwise > confidential or legally privileged. If you have received this > message in error, please notify the sender by reply, and delete all > copies of this message and any attachments. If you are the intended > recipient you may use the information contained in this message and > any files attached to this message only as authorized by Ahold. > Files attached to this message may only be t
Re: UNIX to Windows Remedy Migration
Hi, If you have merge-filters that make use of indexes, it might have a positive impact to have them in place I guess. >From my experience it is unusual to whant merge-filters running in this kind of operation. RRR|Chive has an option to turn on merge-filters using a special switch to the ARMergeEntry()-call. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Would it if there are MERGE filters that do a search on the same form? > Just a question as I have not validated if it would or not.. > > Joe > > > > > From: Rick Cook > To: arslist@ARSLIST.ORG > Sent: Tue, May 4, 2010 10:09:26 AM > Subject: Re: UNIX to Windows Remedy Migration > > If you are going to use an AR method or tool to do data imports, be sure > to drop the indexes on forms that have more than about 100k records. That > will speed the import process significantly. Once the data is imported, > add the indexes back in. > > Rick > > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > -- > This message was scanned by ESVA and is believed to be clean. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: UNIX to Windows Remedy Migration
100k is kind of where you can start to notice the difference, and then it depends on the size of each record and the number of Indexes as to how much of a difference. 100K of a small form, probably no difference. 100k of a large form with 8+ indexes, probably so. Rick -Original Message- From: Misi Mladoniczky Date: Tue, 4 May 2010 18:37:04 To: Subject: Re: UNIX to Windows Remedy Migration Hi, RRR|Chive can drop indexes and recreated after the migration. Have you really seen a big speed difference by doing this? I measured the time for a 100k form with a lot of indexes, and could not see any difference in the speed. I do not remenber which database it was though... Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > If you are going to use an AR method or tool to do data imports, be sure > to drop the indexes on forms that have more than about 100k records. That > will speed the import process significantly. Once the data is imported, > add the indexes back in. > > Rick > > -Original Message- > From: Tim Palmer > Date: Tue, 4 May 2010 10:03:59 > To: > Subject: Re: UNIX to Windows Remedy Migration > > I've done this migration about 5 or 6 years ago. In my opinion that was > the best decision my company made at that time. And yes I'm bias to SQL > server database. The easiest option is to use AR Import to migrate your > data to the new platform. Hopefully you have a programmer who can write > you some windows scripts to run these imports for you. The smaller forms > you can do a full copy and the larger forms it will run based on a date > range. These windows scripts can be set to run at night so you don't have > to watch it and it will not impact your current production during peak > hours. Make sure to have some sort of data integrity check to validate > all > data was migrated over. > > Thanks, > > Timothy Palmer > > > > > Ex Soundgarden >AHOO.COM> To > Sent by: "Action arslist@ARSLIST.ORG > Request System cc > discussion > list(ARSList)"Subject >ORG> > > > 05/04/2010 02:36 > AM > > > Please respond to > arsl...@arslist.o > RG > > > > > > ** > > 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 email message and any attachments are for the sole use of the > intended recipient(s) and may contain information that is > proprietary to Ahold and/or its subsidiaries (Ahold) or o
Re: UNIX to Windows Remedy Migration
Thanks to all who replied to this thread. I listed all the information you provided, and hopefully we can come up with a decision and a drafted strategy. Any more vital information you can give will be taken with greatest consideration. Regards, :gabud > > Ex Soundgarden > AHOO.COM> To > Sent by: "Action arslist@ARSLIST.ORG > Request System cc > discussion > list(ARSList)" Subject > ORG> > > > 05/04/2010 02:36 > AM > > > Please respond to > arsl...@arslist.o > RG > > > > > > ** > > 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 email message and any attachments are for the sole use of the > intended recipient(s) and may contain information that is > proprietary to Ahold and/or its subsidiaries (Ahold) or otherwise > confidential or legally privileged. If you have received this > message in error, please notify the sender by reply, and delete all > copies of this message and any attachments. If you are the intended > recipient you may use the information contained in this message and > any files attached to this message only as authorized by Ahold. > Files attached to this message may only be transmitted using secure > systems and appropriate means of encryption, and must be secured > using the same level of password and security protection with which > the file was provided to you. Any unauthorized use, dissemination > or disclosure of this message or its attachments is strictly > prohibited. > > -- > This message was scanned by ESVA and is believed to be clean. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"