Can multiple AbleCommerce Gold stores use a single database?

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
KenPalmer
Lieutenant (LT)
Lieutenant (LT)
Posts: 54
Joined: Fri Sep 21, 2012 9:50 am

Can multiple AbleCommerce Gold stores use a single database?

Post by KenPalmer » Fri Sep 21, 2012 10:16 am

We have several AbleCommerce 5.5 stores, and are now upgrading one of these stores to AbleCommerce Gold. Eventually we will probably upgrade the other stores, but that is on the distant horizon. With our old stores, we used a single database instance to support all of the stores. Can we do this with AbleCommerce Gold?

I saw the following links. The first didn't really answer the above. And the second indicates a need for the Enterprise solution. We plan to go with Gold, not Enterprise.
viewtopic.php?f=65&t=16752
http://www.ablecommerce.com/Enterprise- ... -P207.aspx

This question came up while I was planning our installation, since we need to assign a Database name in SQL 2008. Can we use a single database to support multiple store instances, or will we need to create separate database instances for each store? Thanks.

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Can multiple AbleCommerce Gold stores use a single database?

Post by Katie » Sat Sep 22, 2012 7:41 am

Hello Ken,

With AC7 and AC Gold, there is going to be one database per installation/store. After version 5, we changed our licensing model. We used to sell a product with 5 stores and 1 server license, and it sold for about $3k. With version 7, we moved to a simpler licensing model that was based on the domain name only. We dropped the price and sold individual store licenses instead of "store packs" and "server keys". So with AC Gold , you'll need to have an installation for each store, and each will need to have it's own database instance, which is more secure anyway.

Welcome to the forums Ken, and thanks for your question.

Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Can multiple AbleCommerce Gold stores use a single database?

Post by jmestep » Sat Sep 22, 2012 8:49 am

Katie- just to make sure I understand this. We have one site that has two domain names applied to the same store database and we did some custom programming to do that. If this site upgrades to Gold, there would be one domain name per database?
I'm asking because we have another client who will be wanting to upgrade to Gold after the first of the year, but they also want a second domain name applied to their Able 7.0.7 store now so they can have the appearance of two stores, with some of the same products, but one admin and database for both domain names.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

KenPalmer
Lieutenant (LT)
Lieutenant (LT)
Posts: 54
Joined: Fri Sep 21, 2012 9:50 am

Re: Can multiple AbleCommerce Gold stores use a single database?

Post by KenPalmer » Mon Sep 24, 2012 12:41 pm

Thanks Katie.

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: Can multiple AbleCommerce Gold stores use a single database?

Post by Logan Rhodehamel » Mon Sep 24, 2012 1:50 pm

Judy, AC Gold still supports multiple domain names for a single installation. What Katie was getting at is that we no longer support different store data sets in the same database - or multiple store ids as it would have been in past versions.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Can multiple AbleCommerce Gold stores use a single database?

Post by jmestep » Tue Sep 25, 2012 6:45 am

Thanks for the info. The client will be happy.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

Post Reply