Different database for Ecommerce & Online Marketing

harshal bundelkhandi asked on April 13, 2020 13:44

Hi Support, I want to separate eCommerce & Online Marketing module data into different database. How can i proceed to this.

Thanks, Harshal

Correct Answer

Brenden Kehren answered on April 13, 2020 18:07

So it looks like you updated your initial question. To answer a couple of your questions you initially had:

  1. You can only separate the contact database from the CMS database. You CANNOT separate the e-commerce portion too.
  2. Your initial question asked if you could separate the requests. This is somewhat of a loaded question. While you can separate the requests from the CMS to the database, you cannot separate the web requests using the process Kadir provided. If you want to split (not separate) the web requests, you still need to do what I was saying and set your environment up in a web farm.
  3. I'd question the need (very highly) to separate the database into 2 databases before you proceed with it. Newer versions of Kentico V10 and higher can handle millions of records in the database without issue. Whereas in older versions, it could not. So if the only reason you're wanting to split them is based on the requests, I'd recommend NOT doing so. If you're splitting them due to size and not being able to backup your database properly or wanting to keep a separate database of your contacts, then by all means do so.
2 votesVote for this answer Unmark Correct answer

Recent Answers

Brenden Kehren answered on April 13, 2020 14:08

Separating the database does not change where the web requests come into. The only way to spread out those requests that I'm aware of is to implement a web farm.

0 votesVote for this answer Mark as a Correct answer

Kadir Ergün answered on April 13, 2020 17:14

I assume that you are looking for this, Separating the contact management database

  1. Open the System application.
  2. Select the DB separation tab and click Separate contact management database.
    • This starts the database separation wizard.
  3. Specify the SQL server to which you wish to transfer the contact management database and enter the connection credentials.
    • You can identify the server through its name or IP address.
    • It is possible to use a different server than the one containing the main database.
    • The separated database may be hosted on all server types supported by Kentico.
3 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.