Script / Automate AppServer and SQL Server Setup

Epicor ERP 10
,
1

Continuing the discussion from Update from 10.2.200.6 to 10.2.200.10 in 45 min:

Has anyone developed On-Prem scripting to setup a complete Epicor environment? My end goal is to take mostly vanilla Windows servers and fully setup Epicor 10. I’m not going to write that all on my 1st try, but I am curious what others have done already.

Are there features that can’t be scripted and I shouldn’t waste my time on?

We are 100 users and use 1 SQL and 3 App servers (interactive, reporting, integrations)

In a perfect world the script would:

SQL:

  • Install SQL Server on correct drives
  • Configure full text & needed flags
  • Install SSRS
  • Copy and attach Epicor10 DB

App servers:

  • Config Check / Check for .Net
  • Install Admin Console
  • Setup DB management
  • Register DB
  • Install App server
    • Different XML for each app server for needed extensions, SSO, etc…
  • Install Task Agent on App1
  • Migrate SSRS reports
  • Migrate Epcior10 DB
  • Regen Data Model
  • Install Enterprise Search
  • Run 1st login conversions
  • Set System Agent settings
  • Set Company settings for Prod or Test environments
  • Make a cup of coffee

Sound like fun?! :slight_smile:

2 Likes
2

I would suggest moving the very last item on the list to be the very first item on the list, so you can have it as you’re watching the action take place.

3 Likes
3

Start with a :coffee: end with a :beer:!

1 Like
4

I would even add :lobster::ice_cream: with :family_woman_girl_boy:, because I would SURELY want to be out of the office by then!

5

Following.

New to Powershell, so I’m not sure how much I could contribute, but hopefully this could be a collaborative effort in github… J

- Steve

1 Like
6

According to @Bart_Elia there is powershell support for all / most of these tasks… I wonder if those sample scripts can be placed somewhere online? Github for us to play with?

1 Like
7

Actually looking at the Epicor Help there is support for most of these via these programs (documented in the help)

  • Ice.Tool.DataModelGenerator.CL.exe Allows you to regen data model

  • DatabaseServerManagerCommandLine.exe Allows you to Add / Update DB Server /DBs

  • Ice.Tool.AdminLicense.exe Install setup licensing

  • SetupEnvironmentUI.exe Create Manage App Servers

2 Likes
8

There’s a command Line Tool Reference Guide on EpicWeb with a ton of examples
https://epicweb.epicor.com/doc/Docs/Epicor10_techrefCommandLine_102200.pdf#search=Using%20Command%20Line%20Tools

Epicor Help Ref
https://epicweb.epicor.com/Education/OnlineHelpFeatureSummary/Epicor%20ERP%2010/10.2.300/Help/enu/Standard/snm_enu.htm#TechRefGuideSystemAdmin/CmdLineIntroduction.html

3 Likes
9

I have reviewed the help and agree that there is a lot of great information in there. Definitely enough to get started and be dangerous (have fun).

What I don’t know is if anyone is actually using these tools in their environment today… and what their experience is.

1 Like
10

Does anyone know of a way to script the install of the Base Install & Admin Console?

The Epicor Command Line Tools Guide for 10.2.300 says to start by installing the “Epicor Administration Console” and I assume the are referring to the base setup RL10.2.300.0.exe

I would like to be able to pass parameters or a config file to set what is installed, and the install location but I can’t find any documentation.

image

11

So admin console can be installed from (your own path)
E:\Epicor\ERP10\ERP10.2.300.0\SupplementalInstalls\Administration
They even have a silent install script

cd "E:\Epicor\ERP10\ERP10.2.300.0\SupplementalInstalls\Administration"
call "E:\Epicor\ERP10\ERP10.2.300.0\SupplementalInstalls\Administration\AdminConsole.msi" /quiet /log "E:\Epicor\ERP10\ERP10.2.300.0\SupplementalInstalls\Administration\AdminConsoleInstall.log"

Looks like base can also be installed silently

e:\installation media\ud10.2.100.7\ERP10.2.100.0.exe /s