Working with more than one type of database

Do you have questions regarding other database enginges (not MySQL) -- ask here!

Moderators: macek, egami, gesf

graham262
New php-forum User
New php-forum User
Posts: 10
Joined: Wed Jul 27, 2005 5:26 pm
Location: Tainan City, Taiwan

Working with more than one type of database

Postby graham262 » Sat Nov 12, 2005 7:32 pm

Ok, here is my situation. I have a database program that uses MySQL on the users local computer (for offline work), but the online version (situated on a server elsewhere) maybe MySQL, Access, Oracle, or something else. When the user makes changes to the db, it stores the SQL query in a log file.

Here's the question, if the user wants to then import the changes (data) in to the online db, can I just load the SQL query in using something like adodb and all is well?? I am try to work with 2 different databases see, and am not sure if this is possible. From what I can see from adodb it takes care of all the communication with the difference databases, you just need to feed it the SQL queries and it does the rest.... I am I too naive :(

Thanks,

Graham.

User avatar
ruturajv
php-forum Super User
php-forum Super User
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India
Contact:

Postby ruturajv » Sun Nov 13, 2005 8:15 pm

I don't know much about access, if it can import SQL queries,
anyways mysql u can take a dump of the dB in SQL queries by using mysqldump utility that comes with mysql server.
I think Access should be able to use simple insert quries..

graham262
New php-forum User
New php-forum User
Posts: 10
Joined: Wed Jul 27, 2005 5:26 pm
Location: Tainan City, Taiwan

Postby graham262 » Sun Nov 13, 2005 11:22 pm

yeah, that's what I'm thinking too. Cheers ruturajv.

G.

User avatar
egami
php-forum GURU
php-forum GURU
Posts: 2196
Joined: Wed Oct 06, 2010 11:19 am
Location: Happy Valley, UT

Re: Working with more than one type of database

Postby egami » Thu Apr 26, 2012 6:06 am

You seriously just tried to answer a question from 7 years ago? :)


Return to “Other Database Engines”

Who is online

Users browsing this forum: Baidu [Spider] and 2 guests