469,622 Members | 2,170 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

Can I Have 2 different RDBMS for a single application

18
Hi friends,

Happy New Year.

Can I have two different RDBMS for a single application, like i would like to store one set of database in MySQL and another set of databases in PostGreSQL. Is it possible? If so, How can I implement it???????


thanx
sarma
Jan 3 '07 #1
5 1262
bartonc
6,596 Expert 4TB
Hi friends,

Happy New Year.

Can I have two different RDBMS for a single application, like i would like to store one set of database in MySQL and another set of databases in PostGreSQL. Is it possible? If so, How can I implement it???????


thanx
sarma
Yes sarma, it is possible. If you tell us your platform and programming language, you may even get examples of such a thing.
Jan 3 '07 #2
sarma
18
Thanx sir..............


I am using One of My RDBMS as MySQL and I am using 'C' to connect to DB. Now I am looking to have another RDBMS.



thanx
sarma
Jan 4 '07 #3
ronverdonk
4,258 Expert 4TB
Just to show a simple setup for your script. As long as you keep the different connections in separate variables.
Expand|Select|Wrap|Line Numbers
  1. Start script
  2. -  connect to server mySQL
  3. -  open connection to database
  4.  
  5. -  connect to server PostGreSQL
  6. -  open connection to database
  7.  
  8. -  use MySQL connection: select from MySQL 
  9. -  use PostGreSQL connection: select from PostGreSQL
  10. -  handle the acquired rows
  11. -  use MySQL connection: issue MySQL command
  12. -  use PostGreSQL connection: issue PostGreSQL command
  13. -  etc.
  14. -  etc.
  15.  
  16. -  close MySQL connection
  17. -  close PostGreSQL connection
  18.  
  19. End script
Ronald :cool:
Jan 4 '07 #4
sarma
18
Ok, ThanQ very much sir

I'll try to follow your guidelines


thanx

sarma
Jan 5 '07 #5
ronverdonk
4,258 Expert 4TB
Hope it works out. When in trouble, come back here.

Ronald :cool:
Jan 5 '07 #6

Post your reply

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

Similar topics

21 posts views Thread by Alexander N. Spitzer | last post: by
1 post views Thread by Marek Kotowski | last post: by
1 post views Thread by Wolfgang Keller | last post: by
4 posts views Thread by Arijit Chatterjee | last post: by
43 posts views Thread by sinister | last post: by
11 posts views Thread by gnewsgroup | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.