Inserting records into SQL Server from Oracle

KAdams

Hello

Has anyone ever grabbed records from oracle and inserted them into SQL
Server. I have been tasked with converting some DTS packages into VB.net
applications. What I want to do is not have the VB app interact with DTS at
all. Any help would be greatly appreciated.

Aug 10 '05 #1

Subscribe Post Reply

1302

W.G. Ryan MVP

have two data adapters, one for Sql Server and one for oracle. The Sql
Server one only needs a valid select command - the oracle one needs only
insert command.

Set the acceptChangesDuringFill property of the SqlServer adapter to false.
Fill the datatable with it.

Then, call update with the Oracle Adapter passing in the same table as the
argument. IF the column names are different, specify them in the colum
mappings collection.

This isn't efficient per se, but it will get you there
"KAdams" <KA****@discussions.microsoft.com> wrote in message
news:A6**********************************@microsof t.com...

Hello

Has anyone ever grabbed records from oracle and inserted them into SQL
Server. I have been tasked with converting some DTS packages into VB.net
applications. What I want to do is not have the VB app interact with DTS
at
all. Any help would be greatly appreciated.

Aug 10 '05 #2

KAdams

I'm fairly new at this so do you have code to do this?

"W.G. Ryan MVP" wrote:

have two data adapters, one for Sql Server and one for oracle. The Sql
Server one only needs a valid select command - the oracle one needs only
insert command.

Set the acceptChangesDuringFill property of the SqlServer adapter to false.
Fill the datatable with it.

Then, call update with the Oracle Adapter passing in the same table as the
argument. IF the column names are different, specify them in the colum
mappings collection.

This isn't efficient per se, but it will get you there
"KAdams" <KA****@discussions.microsoft.com> wrote in message
news:A6**********************************@microsof t.com...
Hello

Has anyone ever grabbed records from oracle and inserted them into SQL
Server. I have been tasked with converting some DTS packages into VB.net
applications. What I want to do is not have the VB app interact with DTS
at
all. Any help would be greatly appreciated.

Aug 11 '05 #3

Similar topics

Fastest for Inserting into Oracle?

by: goldenorb82 | last post by:

Hello, I am a .NET newbie and have been doing a lot of reading to answer my question, but i am guessing that it is so basic, there isn't a lot available out there. Here's my problem: I am...

Oracle Database

I want to transfer ONLY new records AND update any modified records from Oracle into SQL Server using DTS

by: fhadlaq | last post by:

I need a little help here.. I want to transfer ONLY new records AND update any modified records from Oracle into SQL Server using DTS. How should I go about it? a) how do I use global variable...

Microsoft SQL Server

Records across LAN

by: Damon Grieves | last post by:

Hi I just want to be sure I understand how the Access client works. If I have an Access back end with a million records on a server and an Access client. If the client is installed on the users pc...

Microsoft Access / VBA

Inserting records into SQL Server from Oracle

by: KAdams | last post by:

Hello Has anyone ever grabbed records from oracle and inserted them into SQL Server. I have been tasked with converting some DTS packages into VB.net applications. What I want to do is not have...

.NET Framework

Really need help ASAP with ASP, looping, inserting from database SP

by: clinttoris | last post by:

Hello, If someone could help me it would be appreciated as I am not having much luck. I'm struggling with my asp code and have some questions relating to asp and oracle database. First...

ASP / Active Server Pages

Problem in using Connection By in inserting hierarchical data using Oracle 10g.

by: islandfong | last post by:

Hello there, I encounter the following problem when executing a procedure using TOAD connecting to Oracle 10g server. The problem is as following. I have a procedure which is a...

Oracle Database

Duplicate records while inserting the data

by: ebindia0041 | last post by:

This is like the bug from hell. It is kind of hard to explain, so please bear with me. Background Info: SQL Server 7.0, Asp.net 1.1 with c# I'm inserting simple records into a table. But one...

.NET Framework

how to improve my java class performance while selecting and inserting

by: sdanda | last post by:

Hi , Do you have any idea how to improve my java class performance while selecting and inserting data into DB using JDBC Connectivity ......... This has to work for more than 8,00,000...

Java

Problem inserting data using checkboxes and input type=text

by: AlexanderDeLarge | last post by:

Hi! I got a problem that's driving me crazy and I'm desperately in need of help. I'll explain my scenario: I'm doing a database driven site for a band, I got these tables for their discography...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA