473,320 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Is it advisable to use two different databases in two similar System?

Nert
64
Hello there,

I guess i didn't made the title of my question pretty clear, so here's the detail.

In our company, we have this system we called MRP (Material Requirements Planning) System, it was develop using the Visual FoxPro and Ms SQL Database, now my boss wanted me to convert it as a Web-base system using PHP and MySQL DB. We will still use the MRP System made from FoxPro for data inserting/editing, but the data will be save in Ms SQL because it is where System was connected. Now my boss expect that any changes of data in the Ms SQL database will also update the MySQL database.(Will that be possible? If so how?)

I was suggesting to use one database for both MRP System made in FoxPro and for the Web-base System which is the current database Ms SQL so we won't be having problem about data synchronization of two databases. With lots of discussion my boss still insisted to use to database.

Can anyone help me find solution to this problem? Any suggestions? I will appreciate any comment that you guys post.

Please post your comments or suggestions.

Thanks you...
Nov 27 '07 #1
1 1201
code green
1,726 Expert 1GB
Now my boss expect that any changes of data in the Ms SQL database will also update the MySQL database.(Will that be possible? If so how?)
It is possible with a script translating between the two.
Queries do vary across different databse engines.
Nov 27 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Gary L. Burnore | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.mysql This is an invitation to discuss the following proposal to create newsgroup comp.databases.mysql. Please note that YOU CANNOT...
137
by: Philippe C. Martin | last post by:
I apologize in advance for launching this post but I might get enlightment somehow (PS: I am _very_ agnostic ;-). - 1) I do not consider my intelligence/education above average - 2) I am very...
2
by: Kim Christensen | last post by:
After installing MS SQL Server 7 several databases appears in the database folder named: distribution, master, model, msdb, northwind, pubs and tempdb. Is it safe to delete any of those...
2
by: Akinja | last post by:
I have a strange question and hope someone can shed some light on the problem. First let me give you my scenario. We are using doubletake to replicate our database server files between the...
1
by: com | last post by:
Extreme Web Reports 2005 - Soft30.com The wizard scans the specified MS Access database and records information such as report names, parameters and subqueries. ......
1
by: stefari | last post by:
Hi all I have to develop an embedded database using memory FLASH and memory RAM Some tables must be saved in RAM and some tables in FLASH ( RAM and FLASH are two different mounted directories in...
7
by: dad | last post by:
REQ: any utilities for designing front-ends for databases
12
by: pamelafluente | last post by:
Hi guys, In the past I have used several time optional parameters in my function. But Now I am more inclined to think that they are more dangerous than useful, and probably better to be...
21
by: Darin | last post by:
I have an applicatoin that works 100% perfect when running on a machine setup for English (United States), but when I change it to Spanish (Mexico), the dates start giving me fits. THe reason is...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.