E10 Live Company Backup and restore to Test Company

Yahoo Archive
1

Calvin,

 

Are you doing this yourself or with a consultant?

 

We went from Vantage 6 to E9 in 2009.  There is a lot of “bad” data we would like to get rid off and we have mentioned a clean install.

 

I just don’t know how much down time and effort it takes.  Sure we have DMT as well, but do I load each table at a time?

 

We are one company, but manage multi site now as well.  Engineering, Planning, Purchasing and Customer Service and Accounting is all down locally.  By no means no expert in MultiPLant, but I have seen multi issues on E9.  So feel free to ping me anytime you want.

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, July 15, 2016 5:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 Live Company Backup and restore to Test Company.

 

 

Virgin install = Setup of E10 with empty DB's and using DMT.

 

We started on Vista 4 back in the late 1990's.  The upgraded to Vista 8 around 2007 (that was a db conversion of our V4 data).

 

We've since been bought by another company and our "business processes" have changed significantly.  Not to mention the GL structures of our V8 data and that of the new company aren't even close.  So instead of bringing all that baggage (poor implementations of V4 and V8) into E10, we decided to go virgin install + DMT.

 

We've made one significant change in the modules to be utilized.  Prior to being purchased, we had just one site.  Now our site will manage the materials (purchasing, inventory, production etc ...) for several other sites.  So we've added the Multi-site functionality.  Since this feature is brand new to us, we want to experiment with how we setup things related to multiple sites.

 

So having backups made during various points of the initial setup will let us "roll back" to a prior point, and not have to make a whole new company, and redo all the DMT.

 

Calvin

 

 



Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

2

I became quite adept at doing a backup of the live company db, and restoring it to a test company db in V8 (Progress).  But now were starting to transition to E10 (will be a virgin install of E10).


Is there any good documents on how to do it in E10?  Especially during initial setup, so if we find that we did made an irreversible configuration choice we could rollback to the previous day's save point.


Any "gotcha's" that others have run across that might not be explict in the documentation?


Calvin


BTW - the SQL Server is on a different box than our App server (if that makes a difference)


3

Question for you.

 

When you stated Virgin install to E10, are you DMTing the data in?  Or are you actually migrating from Progress to SQL?

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, July 14, 2016 11:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 Live Company Backup and restore to Test Company.

 

 

I became quite adept at doing a backup of the live company db, and restoring it to a test company db in V8 (Progress).  But now were starting to transition to E10 (will be a virgin install of E10).

 

Is there any good documents on how to do it in E10?  Especially during initial setup, so if we find that we did made an irreversible configuration choice we could rollback to the previous day's save point.

 

Any "gotcha's" that others have run across that might not be explict in the documentation?

 

Calvin



BTW - the SQL Server is on a different box than our App server (if that makes a difference)





Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

4

See pp 59-67 in https://epicweb.epicor.com/doc/Docs/Epicor10_techrefSystemAdministration_101400.pdf

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, July 14, 2016 2:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 Live Company Backup and restore to Test Company.

 

 

I became quite adept at doing a backup of the live company db, and restoring it to a test company db in V8 (Progress).  But now were starting to transition to E10 (will be a virgin install of E10).

 

Is there any good documents on how to do it in E10?  Especially during initial setup, so if we find that we did made an irreversible configuration choice we could rollback to the previous day's save point.

 

Any "gotcha's" that others have run across that might not be explict in the documentation?

 

Calvin



BTW - the SQL Server is on a different box than our App server (if that makes a difference)



Posted by: ckrusen1@...

5
Virgin install = Setup of E10 with empty DB's and using DMT.

We started on Vista 4 back in the late 1990's.  The upgraded to Vista 8 around 2007 (that was a db conversion of our V4 data).

We've since been bought by another company and our "business processes" have changed significantly.  Not to mention the GL structures of our V8 data and that of the new company aren't even close.  So instead of bringing all that baggage (poor implementations of V4 and V8) into E10, we decided to go virgin install + DMT.

We've made one significant change in the modules to be utilized.  Prior to being purchased, we had just one site.  Now our site will manage the materials (purchasing, inventory, production etc ...) for several other sites.  So we've added the Multi-site functionality.  Since this feature is brand new to us, we want to experiment with how we setup things related to multiple sites.

So having backups made during various points of the initial setup will let us "roll back" to a prior point, and not have to make a whole new company, and redo all the DMT.

Calvin

 
6
I saw that section of the Admin guide, but it doesn't mention anything special about restoring data from a different DB's backup.

For example, in V8 (with Progress OpenEdge) you have to only partially restart the AppServers, launch the Task Agent, make some changes to port numbers, and then restart the App Servers.

Calvin
7

I backup “Live” db to TEST.bak

Stop App Pool for TEST

Run SQL script to restore “LIVE” as “TEST”

Start TEST app pool

 

Script: (run against Master)

RESTORE DATABASE TEST FROM DISK = 'W:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\TEST.bak'

WITH REPLACE, RECOVERY,

MOVE 'LIVE' to 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\TEST.mdf',

MOVE 'LIVE_Log' to 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\TEST_Log.ldf'

 

Change paths as needed for your environment, Change ‘LIVE’ to your Db name

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, July 15, 2016 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 Live Company Backup and restore to Test Company.

 



I saw that section of the Admin guide, but it doesn't mention anything special about restoring data from a different DB's backup.

 

For example, in V8 (with Progress OpenEdge) you have to only partially restart the AppServers, launch the Task Agent, make some changes to port numbers, and then restart the App Servers.

 

Calvin