I have an external MS SQL Server database that I can display some of its contents within the Drupal 7 views module via the Views Database Connector module.
How can I within Drupal 7 make updates to an external MS SQL Server database?
asked Oct 15, 2015 at 19:37
Add a comment
|
1 Answer
Use the Drupal database API to manipulate the data in the other database. You can use db_set_active() to switch to the other database.
answered Oct 15, 2015 at 21:19
-
Instead of using db_set_active() to switch to the other database I think a better approach is the recommended answer within this link: stackoverflow.com/questions/4839063/… Commented Oct 22, 2015 at 17:31
-
I was citing the official handbook. That said, weird things can happen to things like watchdog() while you are connected to the other database with db_set_active(). And, this question is actually a duplicate of the one you linked. Commented Oct 23, 2015 at 14:50