I am having two databases for the same application , one in windows and the other is web based.Since web based one have few functionalities I can't opt for a single database.At the same time I want to share Both databases to be updated with other's data so as to work error free with my module of appointment fixing.If anyone have a nice solution to this problem please help me with your advise,Thanks.......
views:
63answers:
2
+1
A:
Can you clarify the statement, "Since web based one have few functionalities"? The best option is to use one database for both apps.
Edit:
If the web db only has a minimal set of tables, it should be easy to roll that schema into the other database and then host onh the offsite server. Problem solved...
RedFilter
2009-09-22 04:27:55
It means web based db is only a small part of the other(only meant for appointment module)
2009-09-22 06:01:57
A:
Go for a single database no matter how much wrangling it takes. Two way DB synchronization is not for the faint of heart and I find it hard to believe that you can't find a way to use a single DB.
Even if one of the databases is not feature rich enough ("have few functionalities") use the OTHER one as your single DB.
UPDATE: Here's another thought. It is not unheard of for an application to access two separate databases to do its job. Why not keep both and have the apps query whichever is needed?
JohnFx
2009-09-22 04:42:48
That's nice,but my DBs are in different servers and are at different places.so even if I use a single database how could I update it in each server.
2009-09-22 08:50:47
If you had a DB in a single place you wouldn't NEED to update it on each server. That's kind of my point.
JohnFx
2009-09-22 14:28:46