Can I Have 2 different RDBMS for a single application

[sarma]

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

[bartonc]

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.

[sarma]

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

[ronverdonk]

Just to show a simple setup for your script. As long as you keep the different connections in separate variables.

Start script
-  connect to server mySQL
-  open connection to database
 
-  connect to server PostGreSQL
-  open connection to database
 
-  use MySQL connection: select from MySQL 
-  use PostGreSQL connection: select from PostGreSQL
-  handle the acquired rows
-  use MySQL connection: issue MySQL command
-  use PostGreSQL connection: issue PostGreSQL command
-  etc.
-  etc.
 
-  close MySQL connection
-  close PostGreSQL connection
 
End script

Ronald :cool:

[sarma]

Ok, ThanQ very much sir

I'll try to follow your guidelines


thanx

sarma

[ronverdonk]

Hope it works out. When in trouble, come back here.

Ronald :cool: