Using two databases at the same time with Symfony2

Question

I am currently rebuilding a back-end CMS/CRM/user management system for our front-facing website. Historically, the databases for the two systems have been combined into one, huge, sloppy database (for example CRM data and user data are two separate tables). All of the tables on the website itself, and the back-end system, interface with each other (ie. I can create new users with the back-end system OR register on the website itself).

Now, as I mentioned, I'm rebuilding the system using Symfony2. I'm migrating it to a separate webserver (security, etc.) and therefore migrating it's portion of the DB to its own database. However, I'd still like for it to interact with the website's database.

Is there a relatively simple method in Symfony to make this kind of connection, or does everything need to be hosted in the same database?

ScayTrase · Accepted Answer · 2014-01-15 17:28:24Z

4

CookBook Says you can set up several connections as managers.

Than you can call it as following from the controller

    // both return the "default" em
    $em = $this->get('doctrine')->getManager();
    $em = $this->get('doctrine')->getManager('default');

    $customerEm =  $this->get('doctrine')->getManager('customer');

answered Jan 15, 2014 at 17:28

ScayTrase

1,83023 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using two databases at the same time with Symfony2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related