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 Reply

1316

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 acceptChangesDu ringFill 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****@discuss ions.microsoft. com> wrote in message
news:A6******** *************** ***********@mic rosoft.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 acceptChangesDu ringFill 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****@discuss ions.microsoft. com> wrote in message
news:A6******** *************** ***********@mic rosoft.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

7726

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 creating an API written in C# that connects to the Oracle Database and reads/writes data. I have an array that contains the information that will be...

Oracle Database

4846

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 to get max date. Where and what DTS task should I use to complete the job? Data Driven Query? Transform data task? How ? can u give me samples....

Microsoft SQL Server

2121

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 and run by the user...does Access drag the whole million records across the LAN when we call up one record ie filters for that record locally? If...

Microsoft Access / VBA

270

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 the VB app interact with DTS at all. Any help would be greatly appreciated.

.NET Framework

4713

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 question. I have a web survey that I am working on and have successfully dynamically taken the info from a database, displayed it on the screen and then...

ASP / Active Server Pages

1337

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 statement insert a set of values retrieved by running a SELECT .. FROM ... WHERE ... START WITH ... CONNECT BY statement. It's as following: INSERT...

Oracle Database

6630

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 insert command is placing 2 or 3 records into the table. The 'extra' records, have the same data as the previous insert incident, (except for the...

.NET Framework

2763

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 of records ..... Can you give some performance tips if you have known 1) For this I am using oci driver ( because I m using oracle 10g) instead...

Java

3070

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 section: Discography --------------------- DiscID

PHP

7843

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

8205

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

8339

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7967

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

6619

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

3840

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

2347

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1452

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1185

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General