Database to Database communication
I'm in the planning stage of building a website for a company that I work with. This company is an Electronics wholesaler and wants to get a better web presence. Their current POS system uses PervasiveSQL as the database. I will be using MySQL for the website DB and PHP for the language.
I want to integrate this website with this current database however; i want to have the website use it's own database just in case an intrusion happens, everything won't be compromised. When the website takes in an order I want it also to be duplicated into their POS system.
How do I go about accomplishing this? Do I just write a second INSERT statement in my code and insert into both databases? Is there a method I can use that when the database has something inserted into a table it will trigger an event that takes the information inserted and place it into another database? I ask this because when a new product or customer account is added into the original POS system I want that information to be placed in the websites database.
Copyright License：
Author:「NeonOriginal」,Reproduced under the CC 4.0 BY-SA copyright license with link to original source & disclaimer.
Link to：https://stackoverflow.com/questions/19886621/database-to-database-communication
About “Database to Database communication” questions
I'm trying to understand how actually the communication between Zend framework and the database works (but it's not so easy as it seems ;) ).
My main focus is on Zend_Http_Client_Adapter_Socket c...
|
I am trying to store, modify, and get variables from a mysql database I have set up. I have figured out how to do this using the sql java library. I am loading my Java program using an external cli...
|
I want to make an application for IOS and android using Kivy. The application requires reading and writing to files and also communication with a database server. I am curious wether a kivy applica...
|
I need to design a DB structure that will keep records of Customer Communication information and preferred communication type for certain situations. Basic design will include
Communication Recor...
|
i need to store certain variables in the database and in the storage. but is important to have the certainty that this variables will be saved in the two databases and not only in one, furthermore ...
|
I'm trying to create a diagram for some architecture I'm working on. While doing so I was wondering what type of communication is actually happening between PHP and a MySQL Database. I've used it
|
I am having Java program and MySQL database running on the remote server. Now what I want is to establish a communication and to be able to execute queries (select, insert, delete, update) from java
|
I’m looking for the best approach for developing application which will read data from serial port (rxtx) and store readouts in database. The app will have web interface.
The question is if Tomac...
|
I am a junior software engineer,I like this site and people in it.So,I want to ask my problems to see your answers and suggestions.Then,please don't mad at me for asking without searching.
My prob...
|
So, I've been reading about security in relation to desktop applications and database servers. Previously when I've built applications that are linked to a database, I've taken the easy route and s...
|
|
|