Scribd
Upload
116 views5 pages

Refresh QA with Production Data Guide

The document provides instructions for refreshing the QA environment with production data. It recommends restoring a backup of the production database on a separate server with the recovery mode set to simple and log truncated. It also lists several tables to truncate and steps to verify configurations after refreshing the QA database, including verifying URLs, batch jobs, cluster configuration, websites, reporting servers, and server configuration.

Uploaded by

sdpml
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
116 views5 pages

Refresh QA with Production Data Guide

The document provides instructions for refreshing the QA environment with production data. It recommends restoring a backup of the production database on a separate server with the recovery mode set to simple and log truncated. It also lists several tables to truncate and steps to verify configurations after refreshing the QA database, including verifying URLs, batch jobs, cluster configuration, websites, reporting servers, and server configuration.

Uploaded by

sdpml
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

2014/04/11 08:49 1/5 Refresh QA environment with Production data

Refresh QA environment with Production


data

AX QA SSRS location has changed. The new URL's are:

Web Service: [Link]


Report Manager: [Link]

To reduce the file size of restored QA database, it is recommended that

● Restore backup of production database on a separate server (for example, on


PMCLP-S342\SANDBOX instance)
● Change recovery mode to simple and truncate log

--setting recovery mode to simple


USE [master]
GO
ALTER DATABASE [AX5TEST2] SET RECOVERY SIMPLE WITH NO_WAIT
GO
--shrinking log file
USE [<DBName>]
GO
DBCC SHRINKFILE (N'PMC_AX_TEST_log' , 0, TRUNCATEONLY)
GO

● Truncate following tables:

USE[<DBName>]
TRUNCATE TABLE EMPLAUDITREPORT
GO
TRUNCATE TABLE PMCDATABASELOG
GO
TRUNCATE TABLE DATABASELOG
GO
TRUNCATE TABLE SYSDATABASELOG
GO
TRUNCATE TABLE BANKCHEQUELAYOUT
GO
TRUNCATE TABLE SRSSERVERS
GO
TRUNCATE TABLE EPWEBSITEPARAMETERS
GO
TRUNCATE TABLE CIRTRAIMPORTGROUP
GO
TRUNCATE TABLE KWIKTAGDRAWERTAGFIELDS
GO
TRUNCATE TABLE PMCLPSRSREPORT

Data Integrity Documentation - [Link]


Last
update:
dynamics_ax:refresh_qa_environment_with_production_data [Link]
2013/08/08
12:02

GO
TRUNCATE TABLE PMCLPSRSREPORTPARAMETERS
GO
TRUNCATE TABLE PMCLPSRSREPORTENUMS
GO
TRUNCATE TABLE PMCLPSRSENUMVALUES
GO
TRUNCATE TABLE KWIKTAGPMCDRAWERSETUP
GO
TRUNCATE TABLE SYSWORKFLOWPARAMETERS
GO
TRUNCATE TABLE INSYNCBENEFIT
GO
TRUNCATE TABLE INSYNCBONUS
GO
TRUNCATE TABLE INSYNCCONTACT
GO
TRUNCATE TABLE INSYNCDEPENDENT
GO
TRUNCATE TABLE INSYNCEMPLOYEE
GO
TRUNCATE TABLE INSYNCPAYCODE
GO
TRUNCATE TABLE INSYNCPAYROLL

● Shrink data file


● Take backup and restore to QA database

Once the database has been refreshed, start AOS services and log in to QA to perform following
post-refresh tasks:

● Import [Link] and [Link] into AX. This article explains how to import data into AX.
● Verify that only following two batch jobs exist:

● Verify that Cluster configuration tabs (Administration » Setup » Cluster configuration) look like
below:

[Link] Printed on 2014/04/11 08:49


2014/04/11 08:49 3/5 Refresh QA environment with Production data

● erify that EP websites tabs (Administration » Setup » Internet » Enterprise Portal » Web
sites) look like below:

● Verify that [Link] has content similar to this Excel file


● Verify that Reporting Servers (Administration » Setup » Business analysis » Reporting
Services » Reporting Servers) looks like below:

● Verify that Server configuration tabs (Administration » Setup » Server configuration) look like below:

Data Integrity Documentation - [Link]


Last
update:
dynamics_ax:refresh_qa_environment_with_production_data [Link]
2013/08/08
12:02

● Verify that Workflow URL is as follows:

[Link]

Also, run SSRSReportEnums job.

[Link] Printed on 2014/04/11 08:49


2014/04/11 08:49 5/5 Refresh QA environment with Production data

From:
[Link] - Data Integrity Documentation

Permanent link:
[Link]

Last update: 2013/08/08 12:02

Data Integrity Documentation - [Link]

You might also like