G
Guest
Hi All,
I am working on a Data Project, that involves records (rows) to be inserted from a Table in one database to an exactly similar table in another database. The table names and all field names and values are exactly same.
I am looking for Mass insertions or should i say, the easiest way to insert these records. What are my options? i don't want to use the individual OleDbCommand insert statements since that is a rather slow process.
Also the need to use DataAdapter and the schema details is not the best option since both the tables are exactly same.
However Database 1 is access and the Database 2 is SQL server. (So the connections are different and so on....)
Here is a little desc of the prob
Database1 (TableClientDetials) ----------- > (Insert all Records to) -------> Database2 (TableClientDetails)
From (Access) (On SQL Server)
I am working on a Data Project, that involves records (rows) to be inserted from a Table in one database to an exactly similar table in another database. The table names and all field names and values are exactly same.
I am looking for Mass insertions or should i say, the easiest way to insert these records. What are my options? i don't want to use the individual OleDbCommand insert statements since that is a rather slow process.
Also the need to use DataAdapter and the schema details is not the best option since both the tables are exactly same.
However Database 1 is access and the Database 2 is SQL server. (So the connections are different and so on....)
Here is a little desc of the prob
Database1 (TableClientDetials) ----------- > (Insert all Records to) -------> Database2 (TableClientDetails)
From (Access) (On SQL Server)