DataSet to deferent connection

spartakiran

I'm new to ADO.NET
Can I populate dataset from one database(connection) and update another database with same dataset (with defrent command object connection)

I need to grab data from one database and update another one
(I can do it through data reader by looping through but I want to do it with datasets)

Thanks
Spartakiran

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

spartakiran21y ago
Two completly defrent databases
One is Oracle another is Sybase.
What I need is bulk extractions from one database to another

Database tables are similar(not exactly the same as they are deferent databases)
E.g.
DB1 -- TableA
Col1 varchar
Col2 number

E.g. in DB2 -- TableA
Colx varchar
Coly number
Dave21y ago
How different are the schemas? IE does one table have fields the other doesn't?

If anything, you could create the first Dataset from DatabaseA, then create another Dataset from
a DataAdapter against DatabaseB, copy the information from the first dataset to the second, then use
the DataAdapter to write the information back to DatabaseB.

I'm sure theres a better way, for instance i'm sure theres a way to modify the schema on the tables
in the Dataset, then just use another DataAdapter to write the info back.

Of course, if you can use Stored Procedures on the two servers, you could just do it that way and
not fool around with Datasets.
spartakiran21y ago
No! schemas are deferent
Is it possible to map the column names to update command?
Mihir Solanki21y ago
Yes you can do it... make sure schema of both database tables are same...