Differences

This shows you the differences between two versions of the page.

--- buckets_release_procedure [2011/07/18 09:50] – created stephen
+++ buckets_release_procedure [2017/01/01 20:05] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== Buckets Release Procedure ======
-===== Update Database =====
+===== Update Local Dev Database From Live Production =====
   - Open [[https://p3mssqladmin.secureserver.net/33?uniqueDnsEntry=tgrbuckets.db.2880518.hostedresource.com|SQL Server Web Admin]]
-  - Execute
+  - Execute \\ <code sql>
-<code sql>
 SELECT   DataFillSQL
 FROM     DataFill0p1
@@ Line 13: / Line 12: @@
   - Edit and remove the first line (DataFillSQL - the column heading).
   - Run the ''Generate Everything.bat'' script.
-  - Log on to http://mssql.bucketsoffunds.com/mssql/app/connect.aspx
-  - 64.71.180.27, BucketsUser, LZ1jl8nW
+===== Update Live UAT Database From Local Dev =====
-  - Open the Buckets database.
-  -
+  - Run this against the local dev database: \\ <code sql>
+UPDATE BucketsUser
+SET    UserId = 'https://www.google.com/accounts/o8/id?id=AItOawn-vBsC1mKkkndgXJ-L7ezcLNZNo-8uPS8'
+WHERE  ScreenName = 'Stephen'
+</code>
+  - Backup the database and store the ''.bak'' file in the temp directory.
+  - Run this against the local dev database: \\ <code sql>
+UPDATE BucketsUser
+SET    UserId = 'https://www.google.com/accounts/o8/id?id=AItOawmSf92vlJ8eNmaFrJaO09UwCD2MoINu6r4'
+WHERE  ScreenName = 'Stephen'
+</code>
+  - Zip the ''.bak'' file.
+  - Log on to the [[https://my.netcetera.co.uk/cp/Default.aspx?pid=SpaceMsSql2008&mid=100&ctl=edit_item&ItemID=87963&SpaceID=6612|WebsitePanel]].
+  - Maintenance Tools → Restore.
+  - Upload the zip file.