• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Kman
#1 Posted : Tuesday, April 24, 2007 12:46:24 PM(UTC)
Kman

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!
Regards,
Kim(Kman) Rossey
www.toocoolwebs.com
BVSoftware - MerchantTribe Programming/Design, Database Programming and Business Applications
[email protected]
jetheredge
#2 Posted : Tuesday, April 24, 2007 4:01:04 PM(UTC)
jetheredge

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
Kman
#3 Posted : Tuesday, April 24, 2007 10:41:09 PM(UTC)
Kman

Rank: Member

Joined: 11/25/2003(UTC)
Posts: 370

Thanks Justin!
Regards,
Kim(Kman) Rossey
www.toocoolwebs.com
BVSoftware - MerchantTribe Programming/Design, Database Programming and Business Applications
[email protected]
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.

©2025 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012