Board index   FAQ   Search  
Register  Login
Board index php forum :: Database Other Database Engines

Working with more than one type of database

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

Moderators: macek, egami, gesf

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.
graham262
New php-forum User
New php-forum User
 
Posts: 10
Joined: Wed Jul 27, 2005 5:26 pm
Location: Tainan City, Taiwan

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..
User avatar
ruturajv
php-forum Super User
php-forum Super User
 
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India

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

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

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

Re: Working with more than one type of database

Postby boybawang » Wed Apr 25, 2012 5:59 pm

Might it has something to do with your online and offline connection. The database adapt every changes that takes place when the connection takes in different access.
boybawang
New php-forum User
New php-forum User
 
Posts: 34
Joined: Fri Mar 02, 2012 12:38 am
Location: Illinois

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? :)
User avatar
egami
php-forum GURU
php-forum GURU
 
Posts: 2197
Joined: Wed Oct 06, 2010 11:19 am
Location: Happy Valley, UT

burberry mantel Burberry Outlet Online Sale (2)

Postby galloway8 » Tue Jun 04, 2013 1:35 pm

Most of us remember the dubious ?doctor? in Huckleberry Finn who proclaims to have the cure for any malady. From the back of the crowd his shill would loudly proclaim that he himself had been healed by the magical elixir. Oh my, but the quantity of snake oil they sold before the townsfolk discovered they had been duped ? and the doctor long gone. From the tone of many internet blogs it seems the same buyer?s remorse is lingering in the ?Packaged Application? world.
Doing a search for the following search terms in Google brought up some staggering numbers: "ERP Horror Stories" ? 43,000 search results; "SAP Horror Stories" ? 87,000 search jeremy scott adidas gold wing sneakers 02 results; "CRM Horror Stories" ? 42,000 search results.
Before we get into the discussion of packaged applications let?s take a step back and remember how these wonder cures manifested. In the late 1980?s ? (when disco was dying) manufacturing companies wanted to shape supply chain management and enterprise resource planning. In short, they wanted to encourage the concept of a ?process in a box.? (my quotes). Somehow over the last ten years the industry has forgotten that part about the need for the organizational ?process? to change; and as we shall see, that is a key cause of hidden costs.
To belabor the point of ?snake oil? for just a moment longer ? what exactly is a packaged application?
1. You can?t see the ingredients (What is the quality of the code?)
2. You don?t know the recipe (How was it developed?)
3. You don?t know how it?s to be served (Is it designed for my architecture?)
4. When done - you hope it won?t upset your stomach (Will it run on or corrupt my databases?)
But it heals the sick and will bring peace and joy to the world ? if it?s configured just right!
The top ten hidden costs are ? in no specific order:
1. Unclear requirements
As business requirements evolve and as the business grows, more changes to the package will be needed. This is not new but the story is the same - Business users cannot interpret formal specifications, comprehend ?Use Cases?, or understand ?Screen shots.?
<br adidas jeremy scott uk />2. Extensive Customization Required
?Post development surveys tend to show that most (around 50% of) custom solutions don't meet original expectations and quite regularly completely fail for technical, political jeremy scott adidas leopard shirt and other reasons.?
3. Integration of Multiple Packaged Applications
?Most data in most legacy systems is rubbish? As a result, those companies are more likely to underestimate the cost of the move. ?
4. IT Staffing and where to buy jeremy scott adidas Turnover
Staff turnover among developers is common in organizations that are implementing an ERP solution. Most Programmers are excited to learn a new technology; others are reluctant to embrace change. The good ones know their worth and leave after an implementation.
5. Product and Business Evolution
One factor often underestimated, and seldom calculated, is the business disruption factor. If you have a team of your best people fulltime on a project how can they possibly be participating elsewhere?
6. Excess Functionality
Excess functionality often leads to mistaken and unused functionality, which can cause data quality issues. Additionally, functionality that is not used can cause unnecessary overheads in system processing and database storage.
7. Training Cost for End User
Gartner research found that companies that a budget less than thirteen percent of their costs for training are three times more likely to see their ERP projects run over time and over budget when compared with companies that adidas uk sale online spend 17 percent or more on training.
8. Business Process Changes Required
Packaged Applications were originally intended as a ?Process in a Box.? The intent is to change how a company does business by embracing a software process. However, basic business processes - such as accounting, finance, and general burberry clutch ledger - typically don?t need to be overhauled. When those parts of the Packaged Application are not incorporated more customization is required to turn off those capabilities
9. Vendor Selection
Packaged software vendor selection is not a trivial task. Most organizations need to conduct a comprehensive formal evaluation of the short listed suppliers with the aid of external consultants. This process can take significant resources and months in duration.
10. More Testing Required
Most packages are very complex systems. Interfacing with those systems is not an easy task. Testing the links between COTS packages and other corporate software links have to be built on a case-by-case basis and constitute a cost often overlooked.
A colleague recently proposed that he would rate my list with 1, 7, and 10 as his top three issues. He also commented that the metaphor of packaged applications to Snake Oil was appropriate. I thanked him for his feedback and was feeling quite clever - until I discovered this gem from Scientific America.
Chinese water-snake oil contains 20 percent? of the two types of omega-3 fatty acids most readily used by our bodies? Research since the 1980s has demonstrated the necessity?and efficacy?of omega-3 fatty acids. These acids not only reduce inflammation, such as arthritis pain, but also improve cognitive function and reduce blood pressure, cholesterol and even depression.
So perhaps we can survive a little snake oil after all ? just beware of the hidden costs.

Related articles:


burberry touch for men Burberry Outlet Online Sale

burberry sale men Burberry Outlet Online Sale (56)

burberry womens bags Burberry Outlet Online Sale (
galloway8
New php-forum User
New php-forum User
 
Posts: 200
Joined: Mon Jan 07, 2013 3:36 am


Return to Other Database Engines

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.