DataSet to deferent connection

Question

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

spartakiran · Answer

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

Dave · Answer

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.

spartakiran · Answer

No! schemas are deferent Is it possible to map the column names to update command?

Mihir Solanki · Answer

Yes you can do it... make sure schema of both database tables are same...