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

Options
Go to last post Go to first unread
MikeR  
#1 Posted : Monday, July 29, 2019 9:07:44 AM(UTC)
MikeR

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System, Admin
Joined: 10/18/2018(UTC)
Posts: 183

Thanks: 1 times
Was thanked: 6 time(s) in 6 post(s)
Hello Dimi,

The only tool which we have found that works well for data migration is RedGate SQL Data Compare. There is a full-featured 14-day trial.

https://www.red-gate.com...opment/sql-data-compare/

I think it will be easier to bring over the v9 changes to the freshly upgraded Gold database, as I've found bringing users and orders over to be difficult due to db constraints.
Thank you for your support!
Mike Randolph
AbleCommerce.com

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

Joe Payne2  
#2 Posted : Thursday, August 1, 2019 8:31:50 AM(UTC)
Joe Payne2

Rank: Advanced Member

Groups: HelpDesk, Developers
Joined: 11/9/2018(UTC)
Posts: 564

Thanks: 122 times
Was thanked: 26 time(s) in 25 post(s)
I think what he's asking is all those localization changes made to various text pieces throughout the shopper side. Let's say I update some text in certain buttons and links using the CMS. Are those stored in the DB? Or in a text file?
shari  
#3 Posted : Thursday, August 1, 2019 8:36:18 AM(UTC)
shaharyar

Rank: Advanced Member

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

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

In AC9, the localization changes are stored in DB.
Joe Payne2  
#4 Posted : Thursday, August 1, 2019 8:54:01 AM(UTC)
Joe Payne2

Rank: Advanced Member

Groups: HelpDesk, Developers
Joined: 11/9/2018(UTC)
Posts: 564

Thanks: 122 times
Was thanked: 26 time(s) in 25 post(s)
Ok thanks for letting me know.

I would highly recommend Able consider a new feature for importing/exporting content-related data. Because the previous site design cannot be upgraded, the vast majority of installs will have to follow the exact process detailed by the OP. Asking every client to recreate all those changes manually when they want to go live, or spend $ 515 to migrate changes made in the dev environment will substantially drive up the cost to upgrade.

And that's even assuming the client' dev SQL database and live SQL database are accessible via the internet. Not every environment permits direct SQL Server access. So Red-Gate isn't even going to work in certain environments.
Users browsing this topic
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.