Ahmedovic97 Ответов: 1

Как вставить массовые данные из SQL в oracle с помощью C# ?


I m trying to insert data from table in SQL Database to other tables in oracle database column names are differents. i want to know if there is a methode to perform my code in c# , to  insert into tables in oracle database. I am trying to insert 100000 records. my target is that this insert takes less than 3hours.
  i m not allowed to use procedures i cant access source table from destination tables database and viceversa both tables dont have any indices how can i minimize this time? can i use oracle bulk insert and how? i tried to search oracle bulk insert but it requires some Oracle.DataAccess.Client namespace i dont have it


Что я уже пробовал:

я сделал это с помощью sql-команды 'insert'

1 Ответов

Рейтинг:
2