473,387 Members | 1,470 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,387 software developers and data experts.

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 1514
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

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

Similar topics

21
by: Alexander N. Spitzer | last post by:
If I have a machine with 3 virtual IP addresses (192.168.1.), how can I start 3 instances of the same RMI application (each started with different properties/configs), each listening on the port...
1
by: Marek Kotowski | last post by:
I'm preparing short dictionary and this is the question: are 'RDBMS' and 'database server' synonyms? If not, what are the differences? Thanx in advance. Regards Marek Kotowski Warsaw
125
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...
1
by: Wolfgang Keller | last post by:
Hello, just as an introduction: I'm not a developer by profession, I just need a solution for this within the scope of a single project... What I am looking for is basically a tool (usable for...
39
by: Randell D. | last post by:
Folks, I'm sure this can be done legally, and not thru tricks of the trade - I hope someone can help. I'm writing a 'tool' (a function) which can be used generically in any of my projects. ...
4
by: Arijit Chatterjee | last post by:
I heard that MS Access is not at all a RDBMS.But why? Only the security feature in Access is low.We can't create multiple logins or... Other than that everything is available.So why not a...
43
by: sinister | last post by:
Is MS Access a true RDBMS?
6
by: JB | last post by:
Hi All, I'm building a DLL that can be used by several applications. I'd like to have one single instance of a Class stored in my DLL that would be ("shared") by all the applications using that...
11
by: gnewsgroup | last post by:
First, just in case, BLL = Business Logic Layer and DAL = Data Access Layer. I guess this is really a question about architecture. I believe there are many architect here. Software...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.