Summary

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

Details

Page properties

Content

...	...	@@ -18,6 +18,25 @@
18	18	Create database using current naming scheme in azure (currently by copying a current working database, with the data removed in a later step).
19	19	- User Groups are added automatically through a job within 5 minutes.
20	20
21		-Setup SVC users and delete base database users using "SKL_sqlmi_accesss_SKL.sql"
	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
22	22
23		-
	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	+ - TODO - move to sql commands
	33	+
	34	+Truncate the documents db
	35	+
	36	+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
	37	+
	38	+Create STP using Everest Administrator
	39	+
	40	+Create license using new STP
	41	+
	42	+Test new STP