hi friends my name is aravind n i am working as a project Assistant in BITS,pilani. actully i am not so good in ASP. but i want to work in it.

so i have got a problem here i am using oracle 9i as backend.

what i need to do is there are two databases n i need to copy those databases in to a single database.

here the problem is that those two databases contains tables of similar structure so i need to append the values in a single database i dont want them to override one table with the other one.

so if anyone knows what to do with this plz.. reply me.

or can i connect to two databases using a single Data Source Name..
is that possible and if that is possible hw to do that.

if that is possible my problem is solved.

plz.. help me in this, this is a good question for experts in ASP also..


thanx in advance
bye
aravind

that's a good one.The way I (Not an expert) think it could be done is :

1.I think you need two dsns ,I could be wrong.
2.The fact that both db's are identical helps.
3.Get the table names from the first db ("Select tname from tab").
4.For each of these tables,do "Select * from table".
5.Insert into the corresponding table in the second db,using the second dsn.
6.loop

That's the general idea .

Start with it.And all the best.
There are others here who could help more.


Faustine
--------






:
:
: hi friends my name is aravind n i am working as a project Assistant in BITS,pilani. actully i am not so good in ASP. but i want to work in it.
:
: so i have got a problem here i am using oracle 9i as backend.
:
: what i need to do is there are two databases n i need to copy those databases in to a single database.
:
: here the problem is that those two databases contains tables of similar structure so i need to append the values in a single database i dont want them to override one table with the other one.
:
: so if anyone knows what to do with this plz.. reply me.
:
: or can i connect to two databases using a single Data Source Name..
: is that possible and if that is possible hw to do that.
:
: if that is possible my problem is solved.
:
: plz.. help me in this, this is a good question for experts in ASP also..
:
:
: thanx in advance
: bye
: aravind
:

thanx Faustine

but the problem here can i have DSN's in the same page..
see in ur case what ever u are saying i have to be connected to two databases at a time is this possible if possible how???
hope u reply me back..
bye
aravind


: that's a good one.The way I (Not an expert) think it could be done is :
:
: 1.I think you need two dsns ,I could be wrong.
: 2.The fact that both db's are identical helps.
: 3.Get the table names from the first db ("Select tname from tab").
: 4.For each of these tables,do "Select * from table".
: 5.Insert into the corresponding table in the second db,using the second dsn.
: 6.loop
:
: That's the general idea .
:
: Start with it.And all the best.
: There are others here who could help more.
:
:
: Faustine
: --------
:
:
:
:
:
:
: :
: :
: : hi friends my name is aravind n i am working as a project Assistant in BITS,pilani. actully i am not so good in ASP. but i want to work in it.
: :
: : so i have got a problem here i am using oracle 9i as backend.
: :
: : what i need to do is there are two databases n i need to copy those databases in to a single database.
: :
: : here the problem is that those two databases contains tables of similar structure so i need to append the values in a single database i dont want them to override one table with the other one.
: :
: : so if anyone knows what to do with this plz.. reply me.
: :
: : or can i connect to two databases using a single Data Source Name..
: : is that possible and if that is possible hw to do that.
: :
: : if that is possible my problem is solved.
: :
: : plz.. help me in this, this is a good question for experts in ASP also..
: :
: :
: : thanx in advance
: : bye
: : aravind
: :
:
:

You will need two connection objects.Open one connection with the first dsn, and the second connection with the second dsn>I think I have seen a connection being opened with more than one dsn, though I haven't tried it myself.
It was something like :
con.open "DSN=DSN1,DSN2"

btw,What will you do about the strored procedures,views etc. ?
And,why did you chose ASP ? It could be more easier to handle with something like VB ? Just a thought.

Faustine
-------

:
: thanx Faustine
:
: but the problem here can i have DSN's in the same page..
: see in ur case what ever u are saying i have to be connected to two databases at a time is this possible if possible how???
: hope u reply me back..
: bye
: aravind
:
:
: : that's a good one.The way I (Not an expert) think it could be done is :
: :
: : 1.I think you need two dsns ,I could be wrong.
: : 2.The fact that both db's are identical helps.
: : 3.Get the table names from the first db ("Select tname from tab").
: : 4.For each of these tables,do "Select * from table".
: : 5.Insert into the corresponding table in the second db,using the second dsn.
: : 6.loop
: :
: : That's the general idea .
: :
: : Start with it.And all the best.
: : There are others here who could help more.
: :
: :
: : Faustine
: : --------
: :
: :
: :
: :
: :
: :
: : :
: : :
: : : hi friends my name is aravind n i am working as a project Assistant in BITS,pilani. actully i am not so good in ASP. but i want to work in it.
: : :
: : : so i have got a problem here i am using oracle 9i as backend.
: : :
: : : what i need to do is there are two databases n i need to copy those databases in to a single database.
: : :
: : : here the problem is that those two databases contains tables of similar structure so i need to append the values in a single database i dont want them to override one table with the other one.
: : :
: : : so if anyone knows what to do with this plz.. reply me.
: : :
: : : or can i connect to two databases using a single Data Source Name..
: : : is that possible and if that is possible hw to do that.
: : :
: : : if that is possible my problem is solved.
: : :
: : : plz.. help me in this, this is a good question for experts in ASP also..
: : :
: : :
: : : thanx in advance
: : : bye
: : : aravind
: : :
: :
: :
:
: