BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Steps Necessary After Running Patch Utility Without SQL Scripts
Rank: Member
Joined: 11/25/2003(UTC) Posts: 370
|
Can I just run the SchemaScript.sql and DataScript.sql to update a production database?
Here is how I would like to do SP1 > SP2 on sites with modifications.
Load current site to staging server Load current database to staging as well. Backup both Run the updater againest my staging SP1 site Compare to my backup and adjust code as needed so everything works.
Once all works in staging ..... Take production site offline Run SchemaScript.sql Run DataScript.sql Ftp changed files to production.
I do not want to just run the updater on a production website.
Thanks! |
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC) Posts: 1,142
|
Well, the only issue is that the patcher adds some workflow tasks and runs a bit of sql against the database. You'll need to follow these steps...
-you MUST insert these 'INSERT "Initialize Product Price" task at the top of "Product Pricing" workflow 'INSERT "Apply Product Shipping Modifiers" task into "Shipping Adjustments" workflow
--optional if needed 'INSERT "Google Checkout Send Order Shipped Notification" task into "Shipping Complete" workflow 'INSERT "Google Checkout Send Tracking Information" task into "Package Shipped" workflow 'INSERT "Start Paypal Express Checkout" task into "Third Party Checkout Selected" workflow 'INSERT "Start Google Checkout" task into "Third Party Checkout Selected" workflow
Then run this SQL
UPDATE bvc_WishList SET UserId = bvin, bvin = NEWID() WHERE UserId = '' |
Justin Etheredge Senior Software Engineer BVSoftware |
|
|
|
Rank: Member
Joined: 11/25/2003(UTC) Posts: 370
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.