logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error
Sync new design changes between environments - Sync theme related changes stored in database to other environments
Options
Go to last post Go to first unread
Previous Topic Next Topic
hcd4273248  
#1 Posted : Saturday, December 16, 2023 3:43:56 PM(UTC)
hcd4273248

Rank: Newbie

Groups: Developers
Joined: 1/24/2019(UTC)
Posts: 0

Thanks: 1 times
Hello,

I am trying to change the theme in my Ablecommerce V9 website. have done some changes to the layout in my dev environment. but when I deployed the changes to Staging its not reflecting. Then I did some investigation and figure out that there are database changes as well. How do I migrate those changes to Staging and then to production, I can not restore a dev database to those environments. May I know what I am missing here please.

There are tables has the db changes
[ac_PageTemplateZones]
[ac_WidgetZoneItems]
[ac_WidgetZones]
[ac_LayoutZones]
[ac_Zones]

Thank you

Edited by user Saturday, December 16, 2023 3:45:39 PM(UTC)  | Reason: Not specified
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
shaharyar  
#2 Posted : Monday, December 18, 2023 3:10:55 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
Hi,

Which version of Ablecommerce are you using?
If you are using version 9.0.9, there is a new CMS Data Merge plugin that you can use to sync data between dev and production database.

Alternatively, you need to use a data compare tool like Redgate SQL Compare tool.

1- You upgraded from Gold to AC9. Say it dev db.
2- You worked on dev and made changes in layouts, templates, zones etc
3- When ready to go for production, take a fresh copy of upgraded database
4- Compare the live and dev databases within SQL compare tool and merge the CMS changes into the live database

I hope this helps!

There is another forum thread on this topic.
https://www.ablecommerce...-Database-for-Production

Plese mention any more help is needed!
Back to top
hcd4273248  
#3 Posted : Friday, December 22, 2023 7:11:05 AM(UTC)
hcd4273248

Rank: Newbie

Groups: Developers
Joined: 1/24/2019(UTC)
Posts: 0

Thanks: 1 times
Thank you,
Back to top
Users browsing this topic
Guest (2)
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.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.126 seconds.