E10.1 - Test environment

Yahoo Archive
1

Thank you,

I'll try it out !

Guess I had to go longhand without having good docs or clear info from Epicor support on this one.

Appreciate your help,

Dave

2

We are on Version 10.1.400.11 in our production environment. We also have a separate 10.1 virtual test environment set up. Our dilemma is to refresh our test database we have to restore from a backup (which is no problem) then we need to modify the .ice tables to point to the test environment. This is a cumbersome process which takes time and is susceptible to errors. Is there a migration/copy tool available that can automate this process? We want to maintain this test environment to validate point releases and to test system features we have questions about; having up to date data makes the environment much more valuable/realistic.

 

 

Thanks,

 

Keith Mailloux

 

3
What do you mean modify the ice tables to point to Test?


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Wed, Aug 17, 2016 at 3:24 PM, Keith Mailloux keith.mailloux@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>

We are on Version 10.1.400.11 in our production environment. We also have a separate 10.1 virtual test environment set up. Our dilemma is to refresh our test database we have to restore from a backup (which is no problem) then we need to modify the .ice tables to point to the test environment. This is a cumbersome process which takes time and is susceptible to errors. Is there a migration/copy tool available that can automate this process? We want to maintain this test environment to validate point releases and to test system features we have questions about; having up to date data makes the environment much more valuable/realistic.

Â

Â

Thanks,

Â

Keith Mailloux

 

</div>
 


<div style="color:#fff;min-height:0;"></div>

4
We keep a virtual test environment completely isolated from our Live/Pilot/Test environment for the purpose of testing updates. When we plan an update we will take a copy of the Live Db to the Test environment then perform the update on the test environment. Once the update is complete we take a backup of that, in case we want to go back to it, and then start testing out the new update. If we are happy we update the Live system and leave the Test environment ready for to repeat the process next time. Doing it this way gives us confidence that the Live update will not throw up any surprises. 

Cheers
Brett
5

Hi Jose,

I work with
Keith at Ferguson Perforating.

Our Scenario
here:

                A live physical server called “EPICORSERVER”.

                A development/test virtual
server called “DEV-V-EPIC101” which has a snapshot of live data on it.

                What I have done in the past to
refresh the Test servers data with live data is:

                                Restore a full SQL
backup of live database onto dev server (both databases named EPICOR10)

Update via SSMS, Ice schema table
entries which have entries for EPICORSERVER, either changing the entries to
DEV-V-EPIC101 or deleting the row depending on the table

                I realize direct editing of
these tables is dangerous and would only do it on a Test server.

                This updating did work for us,
we are just wondering if there was something more automatic ?

                I was told by Epicor Support
that what we are looking for does not exist.

Thanks,

Dave
Beberman

ERP Manager

Ferguson Perforating

6
Yeah but my question was more of what Tables specifically, we move DB's all around without any issue and without changing any tables... Just curios as to what you are seeing


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Aug 18, 2016 at 9:35 AM, dbeberman@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p><font face="Times New Roman" size="3">

Hi Jose,

I work with
Keith at Ferguson Perforating.

Our Scenario
here:

               A live physical server called “EPICORSERVER”.

               A development/test virtual
server called “DEV-V-EPIC101” which has a snapshot of live data on it.

               What I have done in the past to
refresh the Test servers data with live data is:

                               Restore a full SQL
backup of live database onto dev server (both databases named EPICOR10)

Update via SSMS, Ice schema table
entries which have entries for EPICORSERVER, either changing the entries to
DEV-V-EPIC101 or deleting the row depending on the table

               I realize direct editing of
these tables is dangerous and would only do it on a Test server.

               This updating did work for us,
we are just wondering if there was something more automatic ?

               I was told by Epicor Support
that what we are looking for does not exist.

Thanks,

Dave
Beberman

ERP Manager

Ferguson Perforating

</div>
 


<div style="color:#fff;min-height:0;"></div>

7

The tables
affected:

 

Ice.ExtServiceRegistration

                - Delete All rows

Ice.SysAgent

                - Delete All rows

Ice.SysAgentSched

                - Delete All rows

Ice.SysCompany

                - Update the single row with

                UPDATE A

                EntSearchURL = ‘’,

                SSRSURL = ‘HTTP://DEV-V-EPIC101/EpiSSRSPortal’

                SMTPServer = ‘’,

                SMTPPort = 0

                FROM EPICOR10.Ice.SysCompany A

Ice.SysConfig

              -Delete Search Server row with

                DELETE FROM EPICOR10.Ice.SysConfig
WHERE Key1 = ‘ESUrl’

 

I wanted to
make sure that anything in the DEV environment would not access any live
resources


-Dave

8
I have been doing restores for a long time and I haven't had any issues, if you run the re-configure in the Admin Console after the upgrade it should update all those tables to point to the "right" place for you.... Though I haven't checked... I haven't had any issues.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Aug 18, 2016 at 10:02 AM, dbeberman@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p><font face="Times New Roman" size="3">

The tables
affected:

Â

Ice.ExtServiceRegistration

               - Delete All rows

Ice.SysAgent

               - Delete All rows

Ice.SysAgentSched

               - Delete All rows

Ice.SysCompany

               - Update the single row with

               UPDATE A

               EntSearchURL = ‘’,

               SSRSURL = ‘HTTP://DEV-V-EPIC101/ EpiSSRSPortal’

               SMTPServer = ‘’,

               SMTPPort = 0

               FROM EPICOR10.Ice.SysCompany A

Ice.SysConfig

             -Delete Search Server row with

               DELETE FROM EPICOR10.Ice.SysConfig
WHERE Key1 = ‘ESUrl’

Â

I wanted to
make sure that anything in the DEV environment would not access any live
resources


-Dave

</div><span class="ygrps-yiv-159677710">
 


<div style="color:#fff;min-height:0;"></div>