buckets_release_procedure

This is an old revision of the document!

Table of Contents

Buckets Release Procedure
- Update Local Dev Database From Live Production
- Update Live UAT Database From Local Dev

Buckets Release Procedure

Update Local Dev Database From Live Production

Open SQL Server Web Admin

Execute

SELECT   DataFillSQL
FROM     DataFill0p1
ORDER BY MajorSortOrder, MinorSortOrder

Export to CSV, Save to C:\Dev\BucketsMVC - Trunk\BucketsMvc.Database\Buckets0.1\40 Data Fill.sql.
Edit and remove the first line (DataFillSQL - the column heading).
Run the Generate Everything.bat script.

Update Live UAT Database From Local Dev

Run this against the local dev database:

UPDATE BucketsUser
SET    UserId = 'https://www.google.com/accounts/o8/id?id=AItOawknyD6ScEP3GiwVXgY-cwr4a7wGK5B_Lpw'
WHERE  ScreenName = 'Stephen'

Backup the database and store the .bak file in the temp directory.

Run this against the local dev database:

UPDATE BucketsUser
SET    UserId = 'https://www.google.com/accounts/o8/id?id=AItOawmSf92vlJ8eNmaFrJaO09UwCD2MoINu6r4'
WHERE  ScreenName = 'Stephen'

Zip the .bak file.
Log on to the WebsitePanel.
Maintenance Tools → Restore.
Upload the zip file.

buckets_release_procedure.1317716465.txt.gz · Last modified: 2017/01/01 19:48 (external edit)