Table of Contents

Buckets Release Procedure

Update Local Dev Database From Live Production

  1. Execute
    SELECT   DataFillSQL
    FROM     DataFill0p1
    ORDER BY MajorSortOrder, MinorSortOrder
  2. Export to CSV, Save to C:\Dev\BucketsMVC - Trunk\BucketsMvc.Database\Buckets0.1\40 Data Fill.sql.
  3. Edit and remove the first line (DataFillSQL - the column heading).
  4. 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.