**

All,

I'm planning on doing the upgrade from our main server to ARS 5.01 (from
4.03). In the course of this, we are also upgrading the OS, machine, and
Sybase. So I figure it will be easiest to do like I did a few years ago,
and just replace the entire machine, dump all the forms, and upload all the
forms to the new machine.

Here my plan:
1> Install new OS/Sybase/ARS on new machine.
2> Dump workflow from current ARS server.
3> Load workflow to new ARS server.
4> Take current ARS server offline.
5> Dump all the data out via each for as reports( is there any quirks to
this? )
6> Import all data that was dumped out.

Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
upgrade a few years ago. The only problem I remeber was a bunch of filters
were firing on the import, can't remeber what I had to do to get around
this, maybe turn off all the filters for that time. Anyone have any
comments?

Thanks
-grant

**

Hi Grant,

I have just done this for a customer and these are the steps that I have
followed in exact order

1. Export all groups and users information (From current production system)
2. Import groups and user form information onto the new server
3. Export Forms and workflow. I would recommend exporting the forms and each
part of the workflow separately. (Current production server)
4. Upload only the forms onto your new server
5. Export data via Remedy user reports (You might want to consider an outage
from this point onwards)
6. Import the data onto the new server. (Make sure you set the preferences
on your import tool as required)
7. Import workflow on the new server

The above steps assume that you have already installed ARS and the Remedy
Help Desk 4.0 application. If you are using help desk 4.0 you may also want
to consider backing up the SHR:ApplicationSettings form on your new server
before deleting all the forms, as this contains the path to some executables
that remedy looks for and you will need the data later on.

Hope this helps. Let me know if I can be of further assistance.

Regards,

Sabyson

----- Original Message -----
From: "Schoep, Grant @ STORM"
To:
Sent: Monday, April 22, 2002 9:36 PM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


> **
>
> All,
>
> I'm planning on doing the upgrade from our main server to ARS 5.01 (from
> 4.03). In the course of this, we are also upgrading the OS, machine, and
> Sybase. So I figure it will be easiest to do like I did a few years ago,
> and just replace the entire machine, dump all the forms, and upload all
the
> forms to the new machine.
>
> Here my plan:
> 1> Install new OS/Sybase/ARS on new machine.
> 2> Dump workflow from current ARS server.
> 3> Load workflow to new ARS server.
> 4> Take current ARS server offline.
> 5> Dump all the data out via each for as reports( is there any quirks to
> this? )
> 6> Import all data that was dumped out.
>
> Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
> upgrade a few years ago. The only problem I remeber was a bunch of filters
> were firing on the import, can't remeber what I had to do to get around
> this, maybe turn off all the filters for that time. Anyone have any
> comments?
>
> Thanks
> -grant
>
>


> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
> You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

**

I would add the steps of disabling all of your Escalations PRIOR to exporting them, so that they don't all start up at once when they're imported, and ensuring that the New server is in Administrator only mode until you're ready to turn the users loose on it.

Rick

-----Original Message-----
From: Sabyson R Fernandes [mailto:sebyritz@YAHOO.COM]
Sent: Mon 4/22/2002 11:18 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Cc:
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated

**

Hi Grant,

I have just done this for a customer and these are the steps that I have
followed in exact order

1. Export all groups and users information (From current production system)
2. Import groups and user form information onto the new server
3. Export Forms and workflow. I would recommend exporting the forms and each
part of the workflow separately. (Current production server)
4. Upload only the forms onto your new server
5. Export data via Remedy user reports (You might want to consider an outage
from this point onwards)
6. Import the data onto the new server. (Make sure you set the preferences
on your import tool as required)
7. Import workflow on the new server

The above steps assume that you have already installed ARS and the Remedy
Help Desk 4.0 application. If you are using help desk 4.0 you may also want
to consider backing up the SHR:ApplicationSettings form on your new server
before deleting all the forms, as this contains the path to some executables
that remedy looks for and you will need the data later on.

Hope this helps. Let me know if I can be of further assistance.

Regards,

Sabyson

----- Original Message -----
From: "Schoep, Grant @ STORM"
To:
Sent: Monday, April 22, 2002 9:36 PM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


> **
>
> All,
>
> I'm planning on doing the upgrade from our main server to ARS 5.01 (from
> 4.03). In the course of this, we are also upgrading the OS, machine, and
> Sybase. So I figure it will be easiest to do like I did a few years ago,
> and just replace the entire machine, dump all the forms, and upload all
the
> forms to the new machine.
>
> Here my plan:
> 1> Install new OS/Sybase/ARS on new machine.
> 2> Dump workflow from current ARS server.
> 3> Load workflow to new ARS server.
> 4> Take current ARS server offline.
> 5> Dump all the data out via each for as reports( is there any quirks to
> this? )
> 6> Import all data that was dumped out.
>
> Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
> upgrade a few years ago. The only problem I remeber was a bunch of filters
> were firing on the import, can't remeber what I had to do to get around
> this, maybe turn off all the filters for that time. Anyone have any
> comments?
>
> Thanks
> -grant
>
>


> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
> You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

**

Ah, that sounds like a good idea to wait and load up the workflow until
AFTER I have imported the data. Will avoid all those things running, and
probably speed it up a great deal too.
-grant


-----Original Message-----
From: Sabyson R Fernandes [mailto:sebyritz@YAHOO.COM]
Sent: Monday, April 22, 2002 12:18 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


**

Hi Grant,

I have just done this for a customer and these are the steps that I have
followed in exact order

1. Export all groups and users information (From current production system)
2. Import groups and user form information onto the new server
3. Export Forms and workflow. I would recommend exporting the forms and each
part of the workflow separately. (Current production server)
4. Upload only the forms onto your new server
5. Export data via Remedy user reports (You might want to consider an outage
from this point onwards)
6. Import the data onto the new server. (Make sure you set the preferences
on your import tool as required)
7. Import workflow on the new server

The above steps assume that you have already installed ARS and the Remedy
Help Desk 4.0 application. If you are using help desk 4.0 you may also want
to consider backing up the SHR:ApplicationSettings form on your new server
before deleting all the forms, as this contains the path to some executables
that remedy looks for and you will need the data later on.

Hope this helps. Let me know if I can be of further assistance.

Regards,

Sabyson

----- Original Message -----
From: "Schoep, Grant @ STORM"
To:
Sent: Monday, April 22, 2002 9:36 PM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


> **
>
> All,
>
> I'm planning on doing the upgrade from our main server to ARS 5.01 (from
> 4.03). In the course of this, we are also upgrading the OS, machine, and
> Sybase. So I figure it will be easiest to do like I did a few years ago,
> and just replace the entire machine, dump all the forms, and upload all
the
> forms to the new machine.
>
> Here my plan:
> 1> Install new OS/Sybase/ARS on new machine.
> 2> Dump workflow from current ARS server.
> 3> Load workflow to new ARS server.
> 4> Take current ARS server offline.
> 5> Dump all the data out via each for as reports( is there any quirks to
> this? )
> 6> Import all data that was dumped out.
>
> Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
> upgrade a few years ago. The only problem I remeber was a bunch of filters
> were firing on the import, can't remeber what I had to do to get around
> this, maybe turn off all the filters for that time. Anyone have any
> comments?
>
> Thanks
> -grant
>
>


> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
> You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Doesn't this plan only work if you have no customizations to your HelpDesk app? It was my understanding that if you have customizations, you will have to move them over to 5.0 individually.

-----Original Message-----
From: Rick Cook [mailto:rcook@DENALIAI.COM]
Sent: Monday, April 22, 2002 11:41 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


**

I would add the steps of disabling all of your Escalations PRIOR to exporting them, so that they don't all start up at once when they're imported, and ensuring that the New server is in Administrator only mode until you're ready to turn the users loose on it.

Rick

-----Original Message-----
From: Sabyson R Fernandes [mailto:sebyritz@YAHOO.COM]
Sent: Mon 4/22/2002 11:18 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Cc:
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated

**

Hi Grant,

I have just done this for a customer and these are the steps that I have
followed in exact order

1. Export all groups and users information (From current production system)
2. Import groups and user form information onto the new server
3. Export Forms and workflow. I would recommend exporting the forms and each
part of the workflow separately. (Current production server)
4. Upload only the forms onto your new server
5. Export data via Remedy user reports (You might want to consider an outage
from this point onwards)
6. Import the data onto the new server. (Make sure you set the preferences
on your import tool as required)
7. Import workflow on the new server

The above steps assume that you have already installed ARS and the Remedy
Help Desk 4.0 application. If you are using help desk 4.0 you may also want
to consider backing up the SHR:ApplicationSettings form on your new server
before deleting all the forms, as this contains the path to some executables
that remedy looks for and you will need the data later on.

Hope this helps. Let me know if I can be of further assistance.

Regards,

Sabyson

----- Original Message -----
From: "Schoep, Grant @ STORM"
To:
Sent: Monday, April 22, 2002 9:36 PM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


> **
>
> All,
>
> I'm planning on doing the upgrade from our main server to ARS 5.01 (from
> 4.03). In the course of this, we are also upgrading the OS, machine, and
> Sybase. So I figure it will be easiest to do like I did a few years ago,
> and just replace the entire machine, dump all the forms, and upload all
the
> forms to the new machine.
>
> Here my plan:
> 1> Install new OS/Sybase/ARS on new machine.
> 2> Dump workflow from current ARS server.
> 3> Load workflow to new ARS server.
> 4> Take current ARS server offline.
> 5> Dump all the data out via each for as reports( is there any quirks to
> this? )
> 6> Import all data that was dumped out.
>
> Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
> upgrade a few years ago. The only problem I remeber was a bunch of filters
> were firing on the import, can't remeber what I had to do to get around
> this, maybe turn off all the filters for that time. Anyone have any
> comments?
>
> Thanks
> -grant
>
>


> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
> You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

**

One other thing - watch the create dates (and created-bys) on your moved entries. It's likely that they'll all be changed to the date on which they were imported. Using Migrator may get you around that.

Rick

-----Original Message-----
From: Linda Hill [mailto:Linda.Hill@SHARP.COM]
Sent: Mon 4/22/2002 1:09 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Cc:
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated

**

Doesn't this plan only work if you have no customizations to your HelpDesk app? It was my understanding that if you have customizations, you will have to move them over to 5.0 individually.

-----Original Message-----
From: Rick Cook [mailto:rcook@DENALIAI.COM]
Sent: Monday, April 22, 2002 11:41 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


**

I would add the steps of disabling all of your Escalations PRIOR to exporting them, so that they don't all start up at once when they're imported, and ensuring that the New server is in Administrator only mode until you're ready to turn the users loose on it.

Rick

-----Original Message-----
From: Sabyson R Fernandes [mailto:sebyritz@YAHOO.COM]
Sent: Mon 4/22/2002 11:18 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Cc:
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated

**

Hi Grant,

I have just done this for a customer and these are the steps that I have
followed in exact order

1. Export all groups and users information (From current production system)
2. Import groups and user form information onto the new server
3. Export Forms and workflow. I would recommend exporting the forms and each
part of the workflow separately. (Current production server)
4. Upload only the forms onto your new server
5. Export data via Remedy user reports (You might want to consider an outage
from this point onwards)
6. Import the data onto the new server. (Make sure you set the preferences
on your import tool as required)
7. Import workflow on the new server

The above steps assume that you have already installed ARS and the Remedy
Help Desk 4.0 application. If you are using help desk 4.0 you may also want
to consider backing up the SHR:ApplicationSettings form on your new server
before deleting all the forms, as this contains the path to some executables
that remedy looks for and you will need the data later on.

Hope this helps. Let me know if I can be of further assistance.

Regards,

Sabyson

----- Original Message -----
From: "Schoep, Grant @ STORM"
To:
Sent: Monday, April 22, 2002 9:36 PM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


> **
>
> All,
>
> I'm planning on doing the upgrade from our main server to ARS 5.01 (from
> 4.03). In the course of this, we are also upgrading the OS, machine, and
> Sybase. So I figure it will be easiest to do like I did a few years ago,
> and just replace the entire machine, dump all the forms, and upload all
the
> forms to the new machine.
>
> Here my plan:
> 1> Install new OS/Sybase/ARS on new machine.
> 2> Dump workflow from current ARS server.
> 3> Load workflow to new ARS server.
> 4> Take current ARS server offline.
> 5> Dump all the data out via each for as reports( is there any quirks to
> this? )
> 6> Import all data that was dumped out.
>
> Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
> upgrade a few years ago. The only problem I remeber was a bunch of filters
> were firing on the import, can't remeber what I had to do to get around
> this, maybe turn off all the filters for that time. Anyone have any
> comments?
>
> Thanks
> -grant
>
>


> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
> You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

**

We actually aren't using any of the default stuff form the HelpDesk app at
all. All our forms are designed/cusomized in house. The few 3rd Party
external apps I have I forgot to mention, but I will also move their
installs to the new server as well.

-grant


-----Original Message-----
From: Linda Hill [mailto:Linda.Hill@SHARP.COM]
Sent: Monday, April 22, 2002 2:09 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


**

Doesn't this plan only work if you have no customizations to your HelpDesk
app? It was my understanding that if you have customizations, you will have
to move them over to 5.0 individually.

-----Original Message-----
From: Rick Cook [mailto:rcook@DENALIAI.COM]
Sent: Monday, April 22, 2002 11:41 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


**

I would add the steps of disabling all of your Escalations PRIOR to
exporting them, so that they don't all start up at once when they're
imported, and ensuring that the New server is in Administrator only mode
until you're ready to turn the users loose on it.

Rick

-----Original Message-----
From: Sabyson R Fernandes [mailto:sebyritz@YAHOO.COM]
Sent: Mon 4/22/2002 11:18 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Cc:
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments
appreciated

**

Hi Grant,

I have just done this for a customer and these are the steps that I have
followed in exact order

1. Export all groups and users information (From current production system)
2. Import groups and user form information onto the new server
3. Export Forms and workflow. I would recommend exporting the forms and each
part of the workflow separately. (Current production server)
4. Upload only the forms onto your new server
5. Export data via Remedy user reports (You might want to consider an outage
from this point onwards)
6. Import the data onto the new server. (Make sure you set the preferences
on your import tool as required)
7. Import workflow on the new server

The above steps assume that you have already installed ARS and the Remedy
Help Desk 4.0 application. If you are using help desk 4.0 you may also want
to consider backing up the SHR:ApplicationSettings form on your new server
before deleting all the forms, as this contains the path to some executables
that remedy looks for and you will need the data later on.

Hope this helps. Let me know if I can be of further assistance.

Regards,

Sabyson

----- Original Message -----
From: "Schoep, Grant @ STORM"
To:
Sent: Monday, April 22, 2002 9:36 PM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


> **
>
> All,
>
> I'm planning on doing the upgrade from our main server to ARS 5.01 (from
> 4.03). In the course of this, we are also upgrading the OS, machine, and
> Sybase. So I figure it will be easiest to do like I did a few years ago,
> and just replace the entire machine, dump all the forms, and upload all
the
> forms to the new machine.
>
> Here my plan:
> 1> Install new OS/Sybase/ARS on new machine.
> 2> Dump workflow from current ARS server.
> 3> Load workflow to new ARS server.
> 4> Take current ARS server offline.
> 5> Dump all the data out via each for as reports( is there any quirks to
> this? )
> 6> Import all data that was dumped out.
>
> Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
> upgrade a few years ago. The only problem I remeber was a bunch of filters
> were firing on the import, can't remeber what I had to do to get around
> this, maybe turn off all the filters for that time. Anyone have any
> comments?
>
> Thanks
> -grant
>
>


> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
> You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Yes - suppose You don't want filtersigger on merge to start working when
importing data...

L Ars

-----Ursprungligt meddelande-----
Fran: Schoep, Grant @ STORM [mailto:GSchoep@STORM.L-3COM.COM]
Skickat: 2002-04-22 22:10
Till: ARSLIST@LISTSERV.VISTAIT.COM
Amne: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


**

Ah, that sounds like a good idea to wait and load up the workflow until
AFTER I have imported the data. Will avoid all those things running, and
probably speed it up a great deal too.
-grant


-----Original Message-----
From: Sabyson R Fernandes [mailto:sebyritz@YAHOO.COM]
Sent: Monday, April 22, 2002 12:18 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


**

Hi Grant,

I have just done this for a customer and these are the steps that I have
followed in exact order

1. Export all groups and users information (From current production system)
2. Import groups and user form information onto the new server
3. Export Forms and workflow. I would recommend exporting the forms and each
part of the workflow separately. (Current production server)
4. Upload only the forms onto your new server
5. Export data via Remedy user reports (You might want to consider an outage
from this point onwards)
6. Import the data onto the new server. (Make sure you set the preferences
on your import tool as required)
7. Import workflow on the new server

The above steps assume that you have already installed ARS and the Remedy
Help Desk 4.0 application. If you are using help desk 4.0 you may also want
to consider backing up the SHR:ApplicationSettings form on your new server
before deleting all the forms, as this contains the path to some executables
that remedy looks for and you will need the data later on.

Hope this helps. Let me know if I can be of further assistance.

Regards,

Sabyson

----- Original Message -----
From: "Schoep, Grant @ STORM"
To:
Sent: Monday, April 22, 2002 9:36 PM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


> **
>
> All,
>
> I'm planning on doing the upgrade from our main server to ARS 5.01 (from
> 4.03). In the course of this, we are also upgrading the OS, machine, and
> Sybase. So I figure it will be easiest to do like I did a few years ago,
> and just replace the entire machine, dump all the forms, and upload all
the
> forms to the new machine.
>
> Here my plan:
> 1> Install new OS/Sybase/ARS on new machine.
> 2> Dump workflow from current ARS server.
> 3> Load workflow to new ARS server.
> 4> Take current ARS server offline.
> 5> Dump all the data out via each for as reports( is there any quirks to
> this? )
> 6> Import all data that was dumped out.
>
> Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
> upgrade a few years ago. The only problem I remeber was a bunch of filters
> were firing on the import, can't remeber what I had to do to get around
> this, maybe turn off all the filters for that time. Anyone have any
> comments?
>
> Thanks
> -grant
>
>


> To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
> You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Hi Grant,

I recommend you performing the upgrade step-by-step.
Benefit 1: If something goes wrong during upgrade you have only one change
to investigate
Benefit 2: reduction of work (no export and import of workflow and data)

Let me explain by giving you the way I should upgrade:
1. Configure new OS on new platform
2. Install current version DBMS on new platform
3. Install current version ARS on new platform (including licences, mail
etc). If you're running e.g. Remedy Help Desk, install that one to to
ensure the installation of the Remedy Application Service.
4. Create backup of database of old platform. Restore backup on new
platform.
5. Copy eventually all custom scripts to the new server
Now you can test if your old application is working on the new platform.
Put it in production for a few days to see all is fine.

6. Upgrade DBMS
Test the application and put it in production for a few days

7. Upgrade ARS
Test .... than in production

This procedure might look time consuming, but I succesfully upgraded
several environments already following the above procedure. In the case the
application is critical, you must be sure to follow the route with minimal
risk of incidents. If you have the resources test this procedure first in a
test-environment.

I hope this helps.

Sincerely,

Patrick Simon, Turnkiek IT Services
tel: +31 (0)33 454 33 55
fax: +31 (0)33 454 33 45
mail: patrick.simon@turnkiek.nl
web: www.turnkiek.nl

-----Original Message-----
From: Schoep, Grant @ STORM [SMTP:GSchoep@STORM.L-3COM.COM]
Sent: Monday, April 22, 2002 7:37 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated

**

All,

I'm planning on doing the upgrade from our main server to ARS 5.01 (from
4.03). In the course of this, we are also upgrading the OS, machine, and
Sybase. So I figure it will be easiest to do like I did a few years ago,
and just replace the entire machine, dump all the forms, and upload all the
forms to the new machine.

Here my plan:
1> Install new OS/Sybase/ARS on new machine.
2> Dump workflow from current ARS server.
3> Load workflow to new ARS server.
4> Take current ARS server offline.
5> Dump all the data out via each for as reports( is there any quirks to
this? )
6> Import all data that was dumped out.

Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
upgrade a few years ago. The only problem I remeber was a bunch of filters
were firing on the import, can't remeber what I had to do to get around
this, maybe turn off all the filters for that time. Anyone have any
comments?

Thanks
-grant



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Sounds like this may be quicker than doing the method I wanted to, as I have
about 15-20 forms that I need to dump data from, then import back. As well
as the fact the server would be remote from me, I would be doing that over a
WAN, where as this method is much quicker becaused I just be sitting at the
UNIX prompts most the whole time.

Question though, doesn't ARS store the server name in there somewhere? So if
I dumped the ARS database, reloaded it on a new machine(with different
name), doesn't that screw things up? Like, when I need to do a export of the
work flow, and have it be "server-independant".

-grant


-----Original Message-----
From: Patrick Simon [mailto:arslist@simon-p.demon.nl]
Sent: Tuesday, April 23, 2002 3:46 AM
To: 'Schoep, Grant @ STORM'
Cc: 'Action Request System discussion list(ARSList)'
Subject: RE: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


Hi Grant,

I recommend you performing the upgrade step-by-step.
Benefit 1: If something goes wrong during upgrade you have only one change
to investigate
Benefit 2: reduction of work (no export and import of workflow and data)

Let me explain by giving you the way I should upgrade:
1. Configure new OS on new platform
2. Install current version DBMS on new platform
3. Install current version ARS on new platform (including licences, mail
etc). If you're running e.g. Remedy Help Desk, install that one to to
ensure the installation of the Remedy Application Service.
4. Create backup of database of old platform. Restore backup on new
platform.
5. Copy eventually all custom scripts to the new server
Now you can test if your old application is working on the new platform.
Put it in production for a few days to see all is fine.

6. Upgrade DBMS
Test the application and put it in production for a few days

7. Upgrade ARS
Test .... than in production

This procedure might look time consuming, but I succesfully upgraded
several environments already following the above procedure. In the case the
application is critical, you must be sure to follow the route with minimal
risk of incidents. If you have the resources test this procedure first in a
test-environment.

I hope this helps.

Sincerely,

Patrick Simon, Turnkiek IT Services
tel: +31 (0)33 454 33 55
fax: +31 (0)33 454 33 45
mail: patrick.simon@turnkiek.nl
web: www.turnkiek.nl

-----Original Message-----
From: Schoep, Grant @ STORM [SMTP:GSchoep@STORM.L-3COM.COM]
Sent: Monday, April 22, 2002 7:37 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated

**

All,

I'm planning on doing the upgrade from our main server to ARS 5.01 (from
4.03). In the course of this, we are also upgrading the OS, machine, and
Sybase. So I figure it will be easiest to do like I did a few years ago,
and just replace the entire machine, dump all the forms, and upload all the
forms to the new machine.

Here my plan:
1> Install new OS/Sybase/ARS on new machine.
2> Dump workflow from current ARS server.
3> Load workflow to new ARS server.
4> Take current ARS server offline.
5> Dump all the data out via each for as reports( is there any quirks to
this? )
6> Import all data that was dumped out.

Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
upgrade a few years ago. The only problem I remeber was a bunch of filters
were firing on the import, can't remeber what I had to do to get around
this, maybe turn off all the filters for that time. Anyone have any
comments?

Thanks
-grant



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Hi Grant,

Your plan seem ok to me except for the fact that you are importing w/f objects before data. If you import data and then workflow you will not have some filters firing during import process.

My 2 cents worth.

Cheers,

Nagendra
Macquarie Bank

-----Original Message-----
From: Schoep, Grant @ STORM [mailto:GSchoep@STORM.L-3COM.COM]
Sent: Wednesday, 24 April 2002 9:17 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


**

Sounds like this may be quicker than doing the method I wanted to, as I have
about 15-20 forms that I need to dump data from, then import back. As well
as the fact the server would be remote from me, I would be doing that over a
WAN, where as this method is much quicker becaused I just be sitting at the
UNIX prompts most the whole time.

Question though, doesn't ARS store the server name in there somewhere? So if
I dumped the ARS database, reloaded it on a new machine(with different
name), doesn't that screw things up? Like, when I need to do a export of the
work flow, and have it be "server-independant".

-grant


-----Original Message-----
From: Patrick Simon [mailto:arslist@simon-p.demon.nl]
Sent: Tuesday, April 23, 2002 3:46 AM
To: 'Schoep, Grant @ STORM'
Cc: 'Action Request System discussion list(ARSList)'
Subject: RE: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


Hi Grant,

I recommend you performing the upgrade step-by-step.
Benefit 1: If something goes wrong during upgrade you have only one change
to investigate
Benefit 2: reduction of work (no export and import of workflow and data)

Let me explain by giving you the way I should upgrade:
1. Configure new OS on new platform
2. Install current version DBMS on new platform
3. Install current version ARS on new platform (including licences, mail
etc). If you're running e.g. Remedy Help Desk, install that one to to
ensure the installation of the Remedy Application Service.
4. Create backup of database of old platform. Restore backup on new
platform.
5. Copy eventually all custom scripts to the new server
Now you can test if your old application is working on the new platform.
Put it in production for a few days to see all is fine.

6. Upgrade DBMS
Test the application and put it in production for a few days

7. Upgrade ARS
Test .... than in production

This procedure might look time consuming, but I succesfully upgraded
several environments already following the above procedure. In the case the
application is critical, you must be sure to follow the route with minimal
risk of incidents. If you have the resources test this procedure first in a
test-environment.

I hope this helps.

Sincerely,

Patrick Simon, Turnkiek IT Services
tel: +31 (0)33 454 33 55
fax: +31 (0)33 454 33 45
mail: patrick.simon@turnkiek.nl
web: www.turnkiek.nl

-----Original Message-----
From: Schoep, Grant @ STORM [SMTP:GSchoep@STORM.L-3COM.COM]
Sent: Monday, April 22, 2002 7:37 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated

**

All,

I'm planning on doing the upgrade from our main server to ARS 5.01 (from
4.03). In the course of this, we are also upgrading the OS, machine, and
Sybase. So I figure it will be easiest to do like I did a few years ago,
and just replace the entire machine, dump all the forms, and upload all the
forms to the new machine.

Here my plan:
1> Install new OS/Sybase/ARS on new machine.
2> Dump workflow from current ARS server.
3> Load workflow to new ARS server.
4> Take current ARS server offline.
5> Dump all the data out via each for as reports( is there any quirks to
this? )
6> Import all data that was dumped out.

Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
upgrade a few years ago. The only problem I remeber was a bunch of filters
were firing on the import, can't remeber what I had to do to get around
this, maybe turn off all the filters for that time. Anyone have any
comments?

Thanks
-grant



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Hi, Grant,

You need to run some sql against your db after step 4 of Patrick's plan,
while ARS is down.

Update servercache set server = 'newserver'

and

update fieldtable set tfserver='newserver' where tfserver='oldserver'


At least this is what I ran doing a 4.0.3 copy-over with Sybase.

Jim.

-----Original Message-----
From: Schoep, Grant @ STORM [mailto:GSchoep@STORM.L-3COM.COM]
Sent: Tuesday, April 23, 2002 4:17 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


**

Sounds like this may be quicker than doing the method I wanted to, as I have
about 15-20 forms that I need to dump data from, then import back. As well
as the fact the server would be remote from me, I would be doing that over a
WAN, where as this method is much quicker becaused I just be sitting at the
UNIX prompts most the whole time.

Question though, doesn't ARS store the server name in there somewhere? So if
I dumped the ARS database, reloaded it on a new machine(with different
name), doesn't that screw things up? Like, when I need to do a export of the
work flow, and have it be "server-independant".

-grant


-----Original Message-----
From: Patrick Simon [mailto:arslist@simon-p.demon.nl]
Sent: Tuesday, April 23, 2002 3:46 AM
To: 'Schoep, Grant @ STORM'
Cc: 'Action Request System discussion list(ARSList)'
Subject: RE: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated


Hi Grant,

I recommend you performing the upgrade step-by-step.
Benefit 1: If something goes wrong during upgrade you have only one change
to investigate
Benefit 2: reduction of work (no export and import of workflow and data)

Let me explain by giving you the way I should upgrade:
1. Configure new OS on new platform
2. Install current version DBMS on new platform
3. Install current version ARS on new platform (including licences, mail
etc). If you're running e.g. Remedy Help Desk, install that one to to
ensure the installation of the Remedy Application Service.
4. Create backup of database of old platform. Restore backup on new
platform.
5. Copy eventually all custom scripts to the new server
Now you can test if your old application is working on the new platform.
Put it in production for a few days to see all is fine.

6. Upgrade DBMS
Test the application and put it in production for a few days

7. Upgrade ARS
Test .... than in production

This procedure might look time consuming, but I succesfully upgraded
several environments already following the above procedure. In the case the
application is critical, you must be sure to follow the route with minimal
risk of incidents. If you have the resources test this procedure first in a
test-environment.

I hope this helps.

Sincerely,

Patrick Simon, Turnkiek IT Services
tel: +31 (0)33 454 33 55
fax: +31 (0)33 454 33 45
mail: patrick.simon@turnkiek.nl
web: www.turnkiek.nl

-----Original Message-----
From: Schoep, Grant @ STORM [SMTP:GSchoep@STORM.L-3COM.COM]
Sent: Monday, April 22, 2002 7:37 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: ARS Server upgrade 4.0 -> 5.01 plan, comments appreciated

**

All,

I'm planning on doing the upgrade from our main server to ARS 5.01 (from
4.03). In the course of this, we are also upgrading the OS, machine, and
Sybase. So I figure it will be easiest to do like I did a few years ago,
and just replace the entire machine, dump all the forms, and upload all the
forms to the new machine.

Here my plan:
1> Install new OS/Sybase/ARS on new machine.
2> Dump workflow from current ARS server.
3> Load workflow to new ARS server.
4> Take current ARS server offline.
5> Dump all the data out via each for as reports( is there any quirks to
this? )
6> Import all data that was dumped out.

Does this sound like an ok plan? This is how I had to do our 3.2 -> 4.0
upgrade a few years ago. The only problem I remeber was a bunch of filters
were firing on the import, can't remeber what I had to do to get around
this, maybe turn off all the filters for that time. Anyone have any
comments?

Thanks
-grant



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org