Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -1,3 +1,4 @@
	1	+(All scripts used are stored on the managed instance under "D:\SKL_Staging_Everest\~_~_skl\scripts" - To be moved to source control)
1	1	Create Files and Folders using current standards (Currently copied from working copy).
2	2	- Rename folder in inetpub/wwwroot to new domain
3	3
...	...	@@ -17,4 +17,24 @@
17	17	Create database using current naming scheme in azure (currently by copying a current working database, with the data removed in a later step).
18	18	- User Groups are added automatically through a job within 5 minutes.
19	19
20		-
	21	+Setup SVC users and delete base database users using "SKL_sqlmi_accesss_SKL.sql"
	22	+ - Enable SQLCMD mode under Query > SQLCMD Mode
	23	+ - Client Code: Three Letter Acronym
	24	+ - TargetEnv: Live | Staging
	25	+ - ClearLogins: 2
	26	+ - Passwords in script to be updated to the ones used above
	27	+
	28	+Update Synonyms for Documents and Audit if relevant
	29	+
	30	+Remove old data using the script "\Dropbox\EBSphere\Everest SQL\Special Scripts\_Debug Scripts [DO NOT RUN]\Script for new Database [DO NOT RUN]\Clear Data [DO NOT RUN].sql"
	31	+ - Ensure that you DO NOT run this on the wrong database
	32	+
	33	+Truncate the documents db
	34	+
	35	+Run dba.dbo.sp_scan_db '%CLIENT[_]%','CLIENT_ENV_Everest' to identify any scripts or tables with old references and update them to reference the new database and client
	36	+
	37	+Create STP using Everest Administrator
	38	+
	39	+Create license using new STP
	40	+
	41	+Test new STP