Table of Contents

Buckets Release Procedure

Update Local Dev Database From Live Production

  1. Open SQL Server Web Admin
  2. Execute 
    SELECT   DataFillSQL
FROM     DataFill0p1
ORDER BY MajorSortOrder, MinorSortOrder
  3. Export to CSV, Save to C:\Dev\BucketsMVC - Trunk\BucketsMvc.Database\Buckets0.1\40 Data Fill.sql.
  4. Edit and remove the first line (DataFillSQL - the column heading).
  5. Run the Generate Everything.bat script.

Update Live UAT Database From Local Dev

  1. Run this against the local dev database: 
    UPDATE BucketsUser
SET    UserId = 'https://www.google.com/accounts/o8/id?id=AItOawn-vBsC1mKkkndgXJ-L7ezcLNZNo-8uPS8'
WHERE  ScreenName = 'Stephen'
  2. Backup the database and store the .bak file in the temp directory.
  3. Run this against the local dev database: 
    UPDATE BucketsUser
SET    UserId = 'https://www.google.com/accounts/o8/id?id=AItOawmSf92vlJ8eNmaFrJaO09UwCD2MoINu6r4'
WHERE  ScreenName = 'Stephen'
  4. Zip the .bak file.
  5. Log on to the WebsitePanel.
  6. Maintenance Tools → Restore.
  7. Upload the zip file.